Night Owl 6

home *** CD-ROM | disk | FTP | other *** search

/ Night Owl 6 / Night Owl's Shareware - PDSI-006 - Night Owl Corp (1990).iso / 050a / dayo1_33.zip / KISBILL.DOC < prev next >

Wrap

Text File | 1991-01-30 | 192KB | 3,213 lines

╔════════════════════════════════════════════════════════════════════════════╗ ║░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░║ ║░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░║ ║░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░║ ║░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░║ ║░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░║ ║░░░░░░░ ▓░░░ ▓░░ ▓░░ ░░░ ▓░░ ▓░░ ▓░░░░░░ ▓░░░░░░░░░║ ║░░░░░░░ ▓░░░ ▓░░░ ▓░░░ ▓░░░░░░░░ ▓░░░░ ▓░░░ ▓░░░ ▓░░░░░░ ▓░░░░░░░░░║ ║░░░░░░░ ▓░░░ ▓░░░ ▓░░░ ▓░░░░░░░░ ▓░░░░ ▓░░░ ▓░░░ ▓░░░░░░ ▓░░░░░░░░░║ ║░░░░░░░ ▓░░ ▓░░░░ ▓░░░ ▓░░░░░░░░ ▓░░░░ ▓░░░ ▓░░░ ▓░░░░░░ ▓░░░░░░░░░║ ║░░░░░░░ ▓░ ▓░░░░░ ▓░░░ ▓░░░░░░░░ ▓░░░░ ▓░░░ ▓░░░ ▓░░░░░░ ▓░░░░░░░░░║ ║░░░░░░░ ▓░░░░░░ ▓░░░ ░░░ ▓░░░░ ▓░░░ ▓░░░░░░ ▓░░░░░░░░░║ ║░░░░░░░ ▓░░░░░░ ▓░░░░░░░░░ ▓░░ ▓░░░░ ▓░░░ ▓░░░ ▓░░░░░░ ▓░░░░░░░░░║ ║░░░░░░░ ▓░ ▓░░░░░ ▓░░░░░░░░░ ▓░░ ▓░░░░ ▓░░░ ▓░░░ ▓░░░░░░ ▓░░░░░░░░░║ ║░░░░░░░ ▓░ ▓░░░░░ ▓░░░░░░░░░ ▓░░ ▓░░░░ ▓░░░ ▓░░░ ▓░░░░░░ ▓░░░░░░░░░║ ║░░░░░░░ ▓░░ ▓░░░░ ▓░░░░░░░░░ ▓░░ ▓░░░░ ▓░░░ ▓░░░ ▓░░░░░░ ▓░░░░░░░░░║ ║░░░░░░░ ▓░░░ ▓░░ ▓░░ ░░░ ░░░ ▓░░ ▓░░ ▓░░░░░║ ║░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░║ ║░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░║ ║░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░║ ║░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░║ ║░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░║ ║░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░║ ╠════════════════════════════════════════════════════════════════════════════╣ ║░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░║ ║░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░║ ║░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░║ ║░░░░░░░░░░░░░░░░░░░░░░ Version 2.1 (29 January 1991) ░░░░░░░░░░░░░░░░░░░░░░░║ ║░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░║ ║░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░║ ║░░░░░░░░░░░░░░░ Keep It Simple Billing & Invoicing System ░░░░░░░░░░░░░░░░░░║ ║░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░║ ║░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░║ ║░░░░░ A Product of TJS LAB, PO Box 585366, Orlando, Florida 32858-5366 ░░░░░║ ║░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░║ ║░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░║ ║░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░║ ╠════════════════════════════════════════════════════════════════════════════╣ ║ ▓▓▓▓▓▓ ███████████▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▐█▌ ║ ║ ▀ ▓▓ ▀ ▓▓▓▓ ▀▀▀▀▀███████████████████████████▌ S ║ ║ ▓▓ ▓▓ ▄▓▓▓▄ ▀████▀▀ ▀████████████ O ║ ║ ▓▓ ▓▓ ▓▓ ▀▀ ███████████ F ║ ║ ▓▓ ▓▓ ▓▓ ▀▓▓▓▄ Specializing In ▐█████████▌ T ║ ║ ▀▓▓▓▀ ▓▓ MicroComputer ██████████ C W ║ ║ ▀▓▓▓▀ & LAN █████■████▌ O A ║ ║ Applications ▐███████████ N R ║ ║ ┌─┐ ┌─┐ ███████████▌ S E ║ ║ ▀▓▓ ▓ ▀▓▄▓▓▓▄ ┌╧─╧┐ ┌─┐ ┌╧─╧┐ ████▀ ▀███ U ║ ║ ▓▓ ▓▓▓ ▓▓ ▓▓ └───╜ ┌╧─╧┐ └───╜ ███ ██▌ L & ║ ║ ▓▓ ▄▓ ▓▄ ▓▓▓▓▓ ░█░ └───╜ ░█░ ███▄▄███ T ║ ║ ▓▓ ▓▓▓▓▓ ▓▓ ▓▓ █████ ░█░ █████ ▀█████▌ I ║ ║ ▓▓▓▓ ▄▓ ▓▄ ▓▀▓▓▓▀ █████ ▀▀▀█ N ║ ║ █ G ║ ║ PO BOX 585366, ORLANDO, FLORIDA 32858-5366 ▄▄▄▄▀ ║ ╚════════════════════════════════════════════════════════════════════════════╝ KISBILL - Keep It Simple Billing and Invoicing System "Try before you buy..." ┌─────────┐ ┌─────┴───┐ │ (tm) ──│ │o │────────────────── │ ┌─────┴╨──┐ │ Association of │ │ │─┘ Shareware └───│ o │ Professionals ──────│ ║ │──────────────────── └────╨────┘ MEMBER This program is produced by a member of the Association of Shareware Professionals (ASP). ASP wants to make sure that the shareware principle works for you. If you are unable to resolve a shareware-related problem with an ASP member by contacting the member directly, ASP may be able to help. The ASP Ombudsman can help you resolve a dispute or problem with an ASP member, but does not provide technical support for members' products. Please write to the ASP Ombudsman at P.O. Box 5786, Bellevue, WA 98006 or send a Compuserve message via easyplex to ASP Ombudsman 70007,3536 ■ SOFTWARE SUPPORT POLICY 1. TJS LAB does not support users of unregistered products with the exception of installation questions. 2. Support (included with registration) remains in effect for 1 year after date of registration or upgrade. 3. Support is available through the following methods: - Phone/Voice Mail: (407) 291-3960/6987 - U.S. Mail: TJS LAB, PO Box 585366, Orlando, FL 32858-5366 - Compuserve Easyplex: 76367,1401 4. Any errors ("bugs or features') in the program will be corrected and the 'fix' sent promptly (via modem if possible). KISBILL - Keep It Simple Billing and Invoicing System Table of Contents Page Subject ──── ─────────────────────────────────────── 1 ................ INTRODUCTION 2 ................ COPYRIGHT/LICENSE 2 ................ DISCLAIMER 2 ................ REQUIREMENTS 2 ................ SETUP 3 ................ MAIN MENU 3 ................ EXIT TO DOS 4 ................ BROWSE, CREATE, MAINTAIN INVOICES 5 ................ INVOICE HEADER FULL SCREEN EDIT - F2 5 ................ BROWSE THE DETAIL RECORDS - F3 6 ................ DETAIL FULL SCREEN EDIT - F2 6 ................ FIND INVOICE NUMBER 6 ................ FIND ITEM NUMBER 6 ................ FIND ITEM DESCRIPTION 7 ................ PRINT/REPRINT INVOICE - F4 8 ................ EXAMPLE OF THE STANDARD INVOICE 9 ................ ADD/CREATE INVOICE - CTRL N 10 ................ ADDING DETAIL ITEMS TO INVOICE 11 ................ SELECT ITEM FROM PAST SALES - F3 11 ................ MANUALLY ADD ITEM - CTRL N 12 ................ DELETE INVOICE - CTRL U 12 ................ RECALCULATE INVOICE SUBTOTAL - CTRL F1 12 ................ FIND INVOICE 12 ................ FIND CUSTOMER NAME 12 ................ FIND CUSTOMER NUMBER 13 ................ FIND CUSTOMER'S PHONE NUMBER 13 ................ FIND CUSTOMER PURCHASE ORDER NUMBER 14 ................ REPORTS 14 ................ REPORTS FORMS 14 ................ REPORTS LISTING 15 ................ HEADER INVOICE REPORT 16 ................ DETAIL INVOICE REPORT 16 ................ EXAMPLE OF THE DETAIL INVOICE REPORT 16 ................ PRODUCT/ITEM LISTING 17 ................ EXAMPLE OF THE PRODUCT/ITEM REPORT 17 ................ DETAIL PRODUCT/ITEM MOVEMENT REPORT 17 ................ EXAMPLE OF THE PRODUCT/ITEM MOVEMENT REPORT 18 ................ CUSTOMERS LIST 18 ................ EXAMPLE OF THE CUSTOMERS LIST 19 ................ ADDRESS & MAILING LABELS 19 ................ EXAMPLE OF ADDRESS/MAILING LABELS 20 ................ FOLDER LABELS KISBILL - Keep It Simple Billing and Invoicing System Table of Contents Page Subject ──── ─────────────────────────────────────── 20 ................ EXAMPLE OF A FOLDER LABEL 20 ................ OPEN INVOICE REPORT 21 ................ SALES GRAPH 21 ................ GRAPH EXAMPLE #1 22 ................ GRAPH EXAMPLE #2 23 ................ CONFIGURATION 23 ................ CONFIGURATION SETTINGS LIST 24 ................ COMPANY NAME 24 ................ COMPANY ADDRESS 24 ................ COMPANY TELEPHONE 25 ................ PRINTER DRIVER (SETUP) 25 ................ PRINTER DRIVER OPTIONS 26 ................ CHANGE DEFAULT PRINTER 27 ................ FULL SCREEN EDIT - F2 27 ................ PRINTER DRIVER DATABASE FIELD DEFINITIONS 28 ................ LAST INVOICE NUMBER 28 ................ PRINTER TYPE 28 ................ INVOICE PRINTER PORT 28 ................ DEFAULT TAX RATE 29 ................ DEFAULT COMMENT 29 ................ SCREEN FONTS 29 ................ SCREEN FONTS LIST 30 ................ READ USER MANUAL 31 ................ SYSTEM 31 ................ REINDEX DATABASES 32 ................ COLOR MONITOR 32 ................ COLOR INTENSITY 33 ................ MISCELLANEOUS ROUTINES 33 ................ MISC ROUTINES MENU: 34 ................ APPEND FROM 36 ................ BROWSE DATABASES 38 ................ COPY (.DBF) TO 40 ................ CREATE DATABASE 42 ................ DELETE RECORDS 43 ................ ERASE FILE 43 ................ EXIT TO DOS 44 ................ INDEX A DATABASE 45 ................ LIST FIELDS 48 ................ MODIFY DATABASE 49 ................ PACK DATABASE 50 ................ RECALL RECORDS KISBILL - Keep It Simple Billing and Invoicing System Table of Contents Page Subject ──── ─────────────────────────────────────── 50 ................ RETURN TO MENU 50 ................ RUN (DOS COMMAND) 51 ................ SIMPLE EDITOR 52 ................ SORT DATABASE 53 ................ TYPE (PRINT) FILE 54 ................ ZAP DATABASE 56 ................ HELP SCREENS 57 ................ EXPANDED HELP 58 ................ USER DEFINED & INPUTTED HELP SCREENS/MESSAGES 60 ................ DATABASE STRUCTURES 61 ................ DATA DICTIONARY 62 ................ TJS 'Computer' LAB 63 ................ ORDER FORM KISBILL - Keep It Simple Billing and Invoicing System Page: 1 KISBILL.EXE Copyright (c) 1989,1990 TJS LAB ■ INTRODUCTION KISBILL is a simple to use and operate billing and invoicing system. This product was produced to provide a means of billing a client or customer. Very little setup is required (ie: Your Company Name, and address). KISBILL utilizes 2 Dbase (tm) compatible databases which contain the invoice header and detail data. The detail database also serves as an inventory/lookup file for later invoices. KISBILL is also multi-user, able to operate on most of the PC based networks, ie: Novell (tm). A simple database management module is also included to provide you with additional means to modify, view or report on your data. Feature Highlights: Menu Driven A Simple DataBase Management System: Unlimited Users - Create databases Multiuser - Edit databases Sales Graph - Create simple reports/lists Dbase (tm) compatible - Append files Read User Manual On Screen - Copy files EGA/VGA Screen Fonts - Simple Editor Tax Rates - Modify databases Laser Formated Invoice Check out KISBILL's big brother 'DAYO Business Applications' if you want more features than KISBILL provides... TJS LAB │ Messages Can Be Left Online At: P.O. Box 585366 │ 4409 Beaumont Drive │ Compuserve: 76367,1401 Orlando, Florida 32858-5366 │ or │ Voice Mail: (407) 291-3960 KISBILL - Keep It Simple Billing and Invoicing System Page: 2 ■ COPYRIGHT/LICENSE This manual and software is copyrighted with all rights reserved by TJS LAB. No copying of this manual or software is authorized without the prior written consent of TJS LAB. No resale of any part of the source codes is authorized without the prior written consent of TJS LAB. The only exception to this rule is the making of backup copies of registered software disks. TJS LAB retains all rights to KISBILL software, documentation, and source codes. ■ DISCLAIMER No warrant is made that this software will work in all environments, or with all resident programs and hardware configurations. TJS LAB has tested this software in many environments and found it to perform as expected, however, this software is licensed "AS IS". TJS LAB will not be liable for any damage done to your data, hardware and/or software systems as a result of using KISBILL. ■ REQUIREMENTS IBM or Compatible CPU, Hard Disk & 640K memory ■ SETUP Setup is made easier with KISBILL. It will create the necessary databases and other files it requires. KISBILL is capable of running on a floppy disk, however, you will be limited in the in number of invoice records. A hard disk is recommended. If you are going to use a hard disk, copy the contents of the KISBILL disk (or UnZip KISBILL.ZIP) onto it, into a directory of its own (ie: \KISBILL). KISBILL - Keep It Simple Billing and Invoicing System Page: 3 ■ MAIN MENU KISBILL V2.1, Copyright (c), 1989, 1990 TJS LAB ┌──[September 1990]──┐ │S M T W T F S │ ╓──────────────────────────╖ ├────────────────────┤ ║ Browse & Create Invoices ║ │ 1│ ╟──────────────────────────╢ Time: 17:08:07 │ 2 3 4 5 6 7 8│ ║ Reports ║ │ 9 10 11 12 13 14 15│ ╟──────────────────────────╢ Drive: D: │16 17 18 19 20 21 22│ ║ Miscellaneous Routines ║ │23 24 25 26 27 28 29│ ╟──────────────────────────╢ Disk Size: 31,950,848 │30 │ ║ Configuration ║ └────────────────────┘ ╟──────────────────────────╢ Available: 13,900,001 ║ Select Routine ║ ╚══════════════════════════╝ ██░ ██░ ████░ ▄██████▄ █▄███████░ ████░ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ████░ ██░ ▀██████▄ █████████░ ██░ ██░ ██░ ██░██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ████░ ▀██████▀ █▀███████░ ████░ ██████░ ██████░ Keep It Simple Billing & Invoicing Esc (Exit To DOS) Invoice Maintenance & Printing ■ EXIT TO DOS Press Esc to bring up a prompt that lets you return to DOS or a calling menu. ╔═══════════════╗ ║╔═════════════╗║ ║║╔═══════════╗║║ ║║║QUIT? (Y/N)║║║ ║║╚═══════════╝║║ ║╚═════════════╝║ ╚═══════════════╝ KISBILL - Keep It Simple Billing and Invoicing System Page: 4 ■ BROWSE, CREATE, MAINTAIN INVOICES This is the browse routine for the invoices. From this routine, you can call/run others as listed at the bottom of the screen. What you are viewing is the records contained in the database INVOICE.DBF. To view the fields not on the screen, press the right/left arrow keys or press F2 to get a full screen edit of the fields. To browse/view the detail records (DETAIL.DBF), you just press F3 and a similar screen will appear. KISBILL V2.1, Copyright (c), 1989, 1990 TJS LAB ┌──[September 1990]──┐ ╔════════════════════════════════════════════════════════════════════════════╗ ║ Invoice: 110 Terms: Customer Number: 110 ║ ║ Taxes: 0.00 Date: 09/17/90 Name: Joe Morgan, Inc. ║ ║ Adjust: 0.00 Attn: Sally ║ ║ Freight: 0.00 Address: PO Box 3433 ║ ║ Subtotal: 37.00 PO: LA, CA 93939 ║ ║ Total: 37.00 ║ ║ Paid: 0.00 Status: Open ║ ║ Due: 37.00 ║ ║ Comment: thank You ║ ╟────────────────────[ BROWSE, CREATE, MAINTAIN INVOICES ]───────────────────╢ ║ INVOICE NAME CUSNUM ║ ║──────────────────────╥────────────────────────────────╥────────────────────║ ║ 105 ║ Homely Bodies ║ 105 ║ ║ 106 ║ Sal's Newspaper Stand ║ 106 ║ ║ 107 ║ Julie Florist ║ 107 ║ ║ 108 ║ Jack Echols ║ 108 ║ ║ 109 ║ Albrieght Corporation ║ 109 ║ ║ 110 ║ Joe Morgan, Inc. ║ 110 ║ ╚════════════════════════════════════════════════════════════════════════════╝ Esc (Exit) F1 (Help) F2 (Edit) F3 (Detail) F4 (Print/Reprint Invoice) Ctrl N (Add) Ctrl U (Delete) Ctrl F1 (Recalc Subtotal) Find: F5 (Invoice) F6 (Name) F7 (Cusnum) F8 (Phone) F9 (Customer PO) 17/17 KISBILL - Keep It Simple Billing and Invoicing System Page: 5 ■ INVOICE HEADER FULL SCREEN EDIT - F2 A full screen edit will display and allow editing of up to 42 fields. KISBILL V2.1, Copyright (c), 1989, 1990 TJS LAB ┌──[September 1990]──┐ ┌────────────────[ EDIT EXISTING INVOICE - FULL SCREEN EDIT ]────────────────┐ │ INVOICE: 110 COMMENT: Thank You │ │ NAME: Mark Smith TAXES: 1.00 │ │ CUSNUM: 110 │ │ ATTN: │ │ ADDRESS1: 1342 Irene St. │ │ ADDRESS2: │ │ CITY: Bath │ │ STATE: SC │ │ ZIP: 23546 │ │ PHONE: 803-555-9087 │ │ TERMS: NET 30 │ │ DATE: 09/17/90 │ │ BY: Jack Lopez │ │ CUST_PO: │ │ TAX: N/A │ │ ADJUST: 1.00 │ │ FREIGHT: 1.00 │ │ SUBTOTAL: 37.00 │ │ OPEN: .T. │ │ PAID: 1.00 │ │ DUE: 39.00 │ └────────────────────────────────────────────────────────────────────────────┘ Press Esc to Abort, PgUp/PgDn to Save and Exit ■ BROWSE THE DETAIL RECORDS - F3 To view the detail records, press F3 from the invoice record browse. Press Esc (once) to exit this routine and return to the browse of the invoice header records. ┌───────────────────[ BROWSE THE DETAIL RECORDS ]───────────────────────┐ │ INVOICE ITEM DESC QTY │ │───────────╥────────────╥────────────────────────────────╥─────────────│ │ 103 ║ EXXXX ║ Jar # 2 ║ 37.000 │ │ 103 ║ FXXXX ║ Jar # 3 ║ 43.000 │ │ 104 ║ GXXXX ║ Jar # 4 ║ 33.933 │ │ 105 ║ HXXXX ║ Jar # 4.1 ║ 2.000 │ │ 105 ║ IXXXX ║ Jar # 4.25 ║ 234.000 │ │ 106 ║ JXXXX ║ Jar # 4.50 ║ 13.000 │ │ 106 ║ KXXXX ║ Jar # 4.75 ║ 54.000 │ │ 107 ║ LXXXX ║ Jar # 4, Red ║ 45.000 │ │ 108 ║ MXXXX ║ Jar # 3100, Tight Cap ║ 31.000 │ │ 109 ║ NXXXX ║ Jar # 3200, Loose Cap ║ 3.000 │ │ 109 ║ OXXXX ║ Jar # 5 ║ 0.000 │ └───────────────────────────────────────────────────────────────────────┘ Esc (Exit) F1 (Help) F2 (Edit) Find: F5 (Invoice) F6 (Item) F7 (Description) Ctrl N (Add) Ctrl U (Delete) KISBILL - Keep It Simple Billing and Invoicing System Page: 6 ■ DETAIL FULL SCREEN EDIT - F2 Like the invoice header records, the detail records can be edited using the full screen edit routine by press F2. KISBILL V2.1, Copyright (c), 1989, 1990 TJS LAB ┌──[September 1990]──┐ ┌───────────────────────────[ FULL SCREEN EDIT ]───────────────────────────┐ │ INVOICE: 4324 │ │ ITEM: FXXXX │ │ DESC: Jar #3 │ │ QTY: 34.000 │ │ PRICE: 3.00 │ │ DATE: 09/02/90 │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ └──────────────────────────────────────────────────────────────────────────┘ Press Esc to Abort, PgUp/PgDn to Save and Exit ■ FIND INVOICE NUMBER ┌─────────────────────────────────────────────────────────────┐ │ Enter INVOICE: 110 │ └───────────────────────────────────────────────────TJS LAB───┘ ■ FIND ITEM NUMBER ┌─────────────────────────────────────────────────────────────┐ │ Enter ITEM: 34546 │ └───────────────────────────────────────────────────TJS LAB───┘ ■ FIND ITEM DESCRIPTION ┌─────────────────────────────────────────────────────────────┐ │ Enter DESC: Widget │ └───────────────────────────────────────────────────TJS LAB───┘ KISBILL - Keep It Simple Billing and Invoicing System Page: 7 ■ PRINT/REPRINT INVOICE - F4 Press F4 to print or reprint any invoice. You will be prompted to enter the number of copies. ╔══════════════════════════════════════════════════════════════════════════╗ ║ Invoice: 110 Customer: 123456 ║ ║ Enter Number of Copies: 2 ║ ║ ║ ║ ║ ╚══════════════════════════════════════════════════════════════════════════╝ After entering in the number of copies, you still have one last chance to align the printer. Press the Enter/Return key to continue. ╔══════════════════════════════════════════════════════════════════════════╗ ║ Invoice: 110 Customer: 123456 ║ ║ Ready your Laser printer, then Press Enter to Start Printing... ║ ║ Press Esc now to abort... ║ ║ ║ ╚══════════════════════════════════════════════════════════════════════════╝ * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * The invoices print onto 8.5 by 11 inch paper at 6 lines per inch with approximately 66 lines per page. * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * The HP printout will do much of the printer setup (ie:LPI & CPI), but no printer setup takes place on the standard printer. *** Note, the HP Laser invoice is more 'elaborate'. Sample of Standard Invoice Next Page. KISBILL - Keep It Simple Billing and Invoicing System Page: 8 ■ EXAMPLE OF THE STANDARD INVOICE Invoice: 1011 Page 1 Date of Invoice: 11/05/89 Date Printed: 11/05/89 16:11:02 Sams Wholesale Distribution Ctr Attn: Accounts Receivable P.O. BOX 335366 Maitland, FL 32458-5366 407-555-5555 Serviced by: Sal -------------------------------------------------------------------------- Customer: 1208 Terms: NET 10 FLOWERS WORLD Customer Po: JOSE Taxable: 0.060 15001 EAST RIVER ROAD SUITE 343 EATONVILLE, FL 93939 393-5555 Comments: I'm sending you a purple ones (out of gold, yellow, and blue) -------------------------------------------------------------------------- ITEM DESCRIPTION QTY PRICE EXTENDED ---------- ------------------------------ ------ ---------- ---------- REG909 RATHER LARGE JAR 4 34.00 136.00 *** Nothing Follows *** -------------------------------------------------------------------------- Sales Total: 136.00 Adjustments: 0.00 Freight/Other: 0.00 Subtotal: 136.00 Tax: 8.16 Net Total: 144.16 -------------------------- Paid:- 0.00 x Balance Due: 144.16 KISBILL - Keep It Simple Billing and Invoicing System Page: 9 ■ ADD/CREATE INVOICE - CTRL N Find an existing customer/client by using the Find keys (F5-F9), then pressing Ctrl N (just press Ctrl N if creating a new customer). A prompt will appear asking if you wish to use the currently highlighted customer. Respond with a Y (Yes) or N (No). Press Esc to abort. An edit screen will appear onto the screen allowing you to enter important 'header' information about the invoice. KISBILL V2.1, Copyright (c), 1989, 1990 TJS LAB ┌──[September 1990]──┐ ┌───────────────────[ ADD A NEW INVOICE - FULL SCREEN EDIT ]─────────────────┐ │ INVOICE: 111 │ │ DATE: 09/18/90 │ │ │ │ NAME: Frank Slater │ │ CUSTOMER NUMBER: 123456 │ │ ATTENTION: │ │ ADDRESS LINE 1: 143 Ivanhoe Blvd. │ │ ADDRESS LINE 2: │ │ CITY: Orlando OPEN: .T. │ │ STATE: Florida AMOUNT PAID: 0.00 │ │ ZIP: 32878 AMOUNT DUE: 0.00 │ │ TELEPHONE: 407-555-5436 │ │ TERMS: Net 30 │ │ SERVICED BY: MG │ │ CUST_PO: │ │ TAX: N 0.00 │ │ ADJUSTMENT: 0.00 │ │ FREIGHT: 0.00 │ │ │ │ COMMENT: Thank You │ │ │ └────────────────────────────────────────────────────────────────────────────┘ Press Esc to Abort, PgUp/PgDn to Save and Exit KISBILL - Keep It Simple Billing and Invoicing System Page: 10 ■ ADDING DETAIL ITEMS TO INVOICE After editing the invoice header record, you will be presented with the following screen. At this point you are to add the detail items to the invoice. You can do this using 2 methods: 1. Press Ctrl N to add a blank record. Enter the information as required 2. Press F3 to bring up a selection browse of all past invoice detail records to select from. KISBILL V2.1, Copyright (c), 1989, 1990 TJS LAB ┌──[September 1990]──┐ ┌───────────────────[ ADD A NEW INVOICE - FULL SCREEN EDIT ]─────────────────┐ │ INVOICE: 112 │ │ DATE: 09/18/90 │ │ │ │ NAME: Tom Johnson │ │ CUSTOMER NUMBER: 112 │ │ ATTENTION: │ │ ADDRESS LINE 1: 4325 Cinderlane Dr. │ │ ADDRESS LINE 2: │ │ ITEM DESCRIPTION QTY PRICE │ │────────────────╥────────────────────────────────╥───────────╥──────────────│ │ ║ ║ ║ │ │ ║ ║ ║ │ │ ║ ║ ║ │ │ ║ ║ ║ │ │ ║ ║ ║ │ │ ║ ║ ║ │ │ ║ ║ ║ │ │ ║ ║ ║ │ │ ║ ║ ║ │ │ ║ ║ ║ │ Esc (Exit) F1 (Help) F2 (Edit) F3 (Add From Detail) Ctrl N (Add) Ctrl U (Delete) Add your line items... (Ctrl N or F3) KISBILL - Keep It Simple Billing and Invoicing System Page: 11 ■ SELECT ITEM FROM PAST SALES - F3 This is the preferred method of adding detail items to your invoice. If you have ever invoiced with this program, you will find the detail items in this selection browse. Find the item, then press the Enter/Return key. ┌──────[ Select an Item to be added to this Invoice ]──────┐ │ ITEM DESC PRICE │ │────────────╥────────────────────────────────╥────────────│ │ 6XXXX ║ Jar #1 ║ 4.00 │ │ AXXXX ║ Jar #2 ║ 3.00 │ │ BXXXX ║ Jar #3 ║ 34.00 │ │ BXXXX ║ Jar #4 ║ 34.00 │ │ FXXXX ║ Jar #5 ║ 3.00 │ │ GXXXX ║ Jar #6 ║ 3.00 │ │ HXXXX ║ Jar #7 ║ 3.00 │ │ IXXXX ║ Jar #8 ║ 3.00 │ └──────────────────────────────────────────────────────────┘ After highlighting the item, press Enter/Return, and you will be presented with a data entry screen for key fields. Use this routine to make any changes to the detail item record while it is being added to the invoice. ┌──────[ Select an Item to be added to this Invoice ]──────┐ │ │ │ Item: GXXXX │ │ Description: Jar #6 │ │ Price: 34.00 │ │ │ │ Enter Qty: 1.0000 │ │ │ │ │ │ │ │ │ └──────────────────────────────────────────────────────────┘ ■ MANUALLY ADD ITEM - CTRL N If the item does not reside in the past sales (DETAIL.DBF), then press Ctrl N to add the item. You need to type the information for all fields. ┌──────────────────────────────────────────────────────────┐ │ Item: HXXXX │ │ Description: Jar #7 │ │ Price: 0.00 │ │ │ │ Enter Qty: 1.0000 │ └──────────────────────────────────────────────────────────┘ KISBILL - Keep It Simple Billing and Invoicing System Page: 12 ■ DELETE INVOICE - CTRL U Press Ctrl U to mark records for deletion, or to recall already deleted records. ■ RECALCULATE INVOICE SUBTOTAL - CTRL F1 Should you change a price value, quantity, freight, taxes, adjustment, or paid fields AFTER creating an invoice, you will need to recompute the invoice subtotal by pressing Ctrl F1. ■ FIND INVOICE ┌─────────────────────────────────────────────────────────────┐ │ Enter INVOICE: 16476 │ └───────────────────────────────────────────────────TJS LAB───┘ ■ FIND CUSTOMER NAME You can enter all or just part (left part) of the name. ┌─────────────────────────────────────────────────────────────┐ │ Enter NAME: Kelly Pace │ └───────────────────────────────────────────────────TJS LAB───┘ ■ FIND CUSTOMER NUMBER ┌─────────────────────────────────────────────────────────────┐ │ Enter CUSNUM: 36474 │ └───────────────────────────────────────────────────TJS LAB───┘ KISBILL - Keep It Simple Billing and Invoicing System Page: 13 ■ FIND CUSTOMER'S PHONE NUMBER This search is on the right 4 digits of the telephone number. ┌─────────────────────────────────────────────────────────────┐ │ Enter RIGHT(SPACE(4)+RTRIM(PHONE),4): 1234 │ └───────────────────────────────────────────────────TJS LAB───┘ ■ FIND CUSTOMER PURCHASE ORDER NUMBER This search is on the purchase order number that your customer may have given you. ┌─────────────────────────────────────────────────────────────┐ │ Enter CUST_PO: 13324-A32 │ └───────────────────────────────────────────────────TJS LAB───┘ KISBILL - Keep It Simple Billing and Invoicing System Page: 14 ■ REPORTS There are 7 Report, 1 Graph, and 2 Label routines available from the Reports Menu. Most of the reports can be directed to a printer or to a file. A few of the reports let you set the date range and select an index (ie: sorted on INVOICE, or NAME). Press Esc to exit this menu... ■ REPORT FORMS There are 5 report forms required: INVOICE.FRM - Used with options 1,9 DETAIL.FRM - Used with option 2 ITEM.FRM - Used with option 3 MOVEMENT.FRM - Used with option 4 CUSTOMER.FRM - Used with options 5,6 ╔════════════════════════════[ REPORTS MENU ]════════════════════════════╗ ║ Select Report Option ║ ╟────────────────────────────────────────────────────────────────────────╢ ║ 1 - Header Invoice Report (With Date Range & Index Selection) ║ ║ 2 - Detail Invoice Report (With Date Range & Index Selection) ║ ║ 3 - Product/Item Listing (Unique ITEM) ║ ║ 4 - Product/Item Movement (With Date Range) ║ ║ 5 - Customers (Unique CUSNUM) ║ ║ 6 - Customers (Unique NAME) ║ ║ 7 - Address/Mailing Labels ║ ║ 8 - Folder Labels (CUSNUM, NAME) ║ ║ 9 - Open Invoices ║ ╚════════════════════════════════════════════════════════════════════════╝ ■ REPORTS LISTING Header Invoice Report (With Date Range & Index Selection) Detail Invoice Report (With Date Range & Index Selection) Product/Item Listing (Unique ITEM) Product/Item Movement (With Date Range) Customers (Unique CUSNUM) Customers (Unique NAME) Address/Mailing Labels Folder Labels (CUSNUM, NAME) Open Invoices Graph KISBILL - Keep It Simple Billing and Invoicing System Page: 15 ■ HEADER INVOICE REPORT Use this report to list all your invoice header records (from the INVOICE.DBF). This report gives you the option to set the date range of invoices you want included on the report (from the DATE field in INVOICE.DBF). You can also select 1 of 3 indexes, type in any heading you want (just defaults to your company name), and tell it where you want the printout to go (printer or file). ┌───[ Header Invoice Report (With Date Range & Index Selection) ]─────┐ │ Start Date: 10/12/89 │ │ End Date: 11/11/89 │ │ Select Index: 1 1-Invoice 2-Name 3-Cusnum │ │ Heading: TJS LAB │ │ Printer or File: 1 1-Printer 2-File │ │ │ └─────────────────────────────────────────────────────────────────────┘ * This report is 132 character wide... KISBILL - Keep It Simple Billing and Invoicing System Page: 16 ■ DETAIL INVOICE REPORT Use this report to list all your invoice detail records (from the DETAIL.DBF). ┌───[ Detail Invoice Report (With Date Range & Index Selection) ]─────┐ │ Start Date: 10/12/89 │ │ End Date: 11/11/89 │ │ Select Index: 1 1-Invoice 2-Item │ │ Heading: TJS LAB │ │ Printer or File: 1 1-Printer 2-File │ │ │ └─────────────────────────────────────────────────────────────────────┘ ■ EXAMPLE OF THE DETAIL INVOICE REPORT Page No. 1 TJS LAB 11/11/89 INVOICE DETAIL EXTENDED INVOICE ITEM DESCRIPTION QTY PRICE TOTAL -------- ---------- ------------------------------ ----- ---------- ---------- 1 MISSILE1 3MT BOMB 1 102.00 102.00 121 MG34 MACHINE GUNS MODEL 34LLD 1 643.00 643.00 141 PISTOL3 PISTOL MODEL III 1 243.00 243.00 156 REG909 RATHER LARGE CARPET 45 10.00 450.00 334 REG909 RATHER LARGE CARPET 2 10.00 20.00 465 REG909 RATHER LARGE CARPET 2 10.00 20.00 677 REG909 RATHER LARGE CARPET 2 10.00 20.00 ■ PRODUCT/ITEM LISTING Use this report to list all 'unique' items in your DETAIL.DBF. This report has only 2 options; the Heading and printing to printer or file. The index is on ITEM. ┌───────────────────────[ Product/Item Listing ]──────────────────────┐ │ Heading: TJS LAB │ │ Printer or File: 1 1-Printer 2-File │ │ │ └─────────────────────────────────────────────────────────────────────┘ KISBILL - Keep It Simple Billing and Invoicing System Page: 17 ■ EXAMPLE OF THE PRODUCT/ITEM REPORT Page No. 1 TJS LAB 11/11/89 PRODUCT/ITEM REPORT ITEM DESCRIPTION PRICE REMARKS ---------- ------------------------------ ---------- ------------------------ 1 Jar 34.30 ________________________ 2 Big Jar 3.24 ________________________ 3 Little Jar 243.00 ________________________ 5Y Yellow Jar 170.99 ________________________ 6 Missing Jar 433.34 ________________________ 8 Wide Mouth Jar 33.00 ________________________ 9 2 Mouth Jar 334.00 ________________________ 10 3 Sided Jar 99.99 ________________________ ■ DETAIL PRODUCT/ITEM MOVEMENT REPORT Use this report to determine how much of each unique ITEM you have sold in any date range. The index is on ITEM. ┌─────────[ Detail Product/Item Movement (With Date Range) ]──────────┐ │ Start Date: 10/12/89 │ │ End Date: 11/11/89 │ │ │ │ Heading: TJS LAB │ │ Printer or File: 1 1-Printer 2-File │ └─────────────────────────────────────────────────────────────────────┘ ■ EXAMPLE OF THE PRODUCT/ITEM MOVEMENT REPORT Page No. 1 TJS LAB 11/11/89 PRODUCT/ITEM MOVEMENT REPORT EXTENDED INVOICE QTY PRICE TOTAL -------- ----- ---------- ---------- ** ITEM: 1 DESCRIPTION: 1928 CAR 121 1 12102.00 12102.00 ** Subtotal ** 1 12102.00 ** ITEM: 1020RED DESCRIPTION: RED ROOSTER 20 3 34.00 102.00 21 3 34.00 102.00 2018 43 34.00 1462.00 ** Subtotal ** 49 1664.00 KISBILL - Keep It Simple Billing and Invoicing System Page: 18 ■ CUSTOMERS LIST Use these 2 reports to create a list of all your active customers. Will print only one record (from the INVOICE.DBF) for each unique CUSNUM and/or NAME. The index in on CUSNUM for option 5, on NAME for option 6. ┌───────────────────[ Customers (Unique CUSNUM) ]─────────────────────┐ │ Heading: TJS LAB │ │ Printer or File: 1 1-Printer 2-File │ │ │ └─────────────────────────────────────────────────────────────────────┘ ┌────────────────────[ Customers (Unique NAME) ]──────────────────────┐ │ Heading: TJS LAB │ │ Printer or File: 1 1-Printer 2-File │ │ │ └─────────────────────────────────────────────────────────────────────┘ ■ EXAMPLE OF THE CUSTOMERS LIST Page No. 1 TJS LAB 11/11/89 CUSTOMERS --------- PHONE TERMS CUSNUM NAME & ADDRESS DATE REMARKS -------- ------------------------------ -------------- -------------------- 1202 YELLOW REEDS STORE 342-5555 ____________________ HERMAN GREEN COD 1234 RED LANE 11/05/89 SUITE BLUE 3 WINTER PARK, FL 39393 1203 U GET IT PICKUP AND DELIVERY 304-5555 ____________________ JOE CASH 123 BEAUMONT DRIVE 11/15/87 ORLANDO, FL 39393 1208 FLOWERS WORLD 393-5555 ____________________ JOSE NET 10 15001 EAST RIVER ROAD 10/05/88 SUITE 343 EATONVILLE, FL 93939 1204 GEORGE HARPER WASHINGTON 291-3960 ____________________ Georgy NET 30 24W Minister Road 11/23/89 Harper St Winter Park, fl 2343 33 KISBILL - Keep It Simple Billing and Invoicing System Page: 19 ■ ADDRESS & MAILING LABELS Use this option to print address or mailing labels onto the standard label (3.5 inches by 15/16 inches) Mount the labels into your printer, and when ready, just press Enter on the selected Invoice/Customer record to print it. Those records that have been printed will be displayed at the top of the screen. Print as many as you want. KISBILL - KEEP IT SIMPLE BILLING & INVOICING PROGRAM ┌───[November 1989]──┐ TJS LAB (Version 2.1) │S M T W T F S │ Invoi┌───────────────────────────────────────┐ ├────────────────────┤ Customer Numb│ 3 GEORGE HARPER WASHINGTON │ │ 1 2 3 4│ Da│ 4 GEORGE HARPER WASHINGTON │ │ 5 6 7 8 9 10 11│ ┌────────────│ 5 YELLOW REEDS STORE │──────────────────┐ 18│ │ Select the │ 6 FLOWERS WORLD │ │ 25│ │ 1 - Header│ 7 EARL WOODS │Selection) │ │ ─│ 2 - Detail└───────────────────────────────────────┘Selection) │──┐│ │ ┌────────────────────[ ADDRESS & MAILING LABELS ]─────────────────────┐ │┘ │ │ INVOICE NAME CUSNUM │ │ │ │─────────────────╥────────────────────────────────╥──────────────────│ │─ │ │ 2019 ║ EARL WOODS ║ 1201 │ │ ─│ │ 2021 ║ HARPER BOOKS ║ 1200 │──┘ │ │ 2022 ║ JOHNSON BROS. ║ 1204 │ │ │ 2024 ║ GEORGE HARPER WASHINGTON ║ 1204 │ │ │ 2025 ║ YELLOW REEDS STORE ║ 1202 │ └─│ 2026 ║ SDF ║ 324 │ ├─────────────────────────────────────────────────────────────────────┤ │ Esc (Exit) Enter (Print Highlighted Label) F5,F6,F7 (Find) │ └─────────────────────────────────────────────────────────────────────┘ Esc (Exit) F1 (Help) F2 (Edit) F3 (Detail) F4 (Print) Alt G (Graph) F5 (Find Invoice) F6 (Find Name) F7 (Find Cusnum) F8 (Recalc Subtotal) Ctrl N (Add) Ctrl U (Delete) Alt M (Misc Routines) Alt S (Setup) ■ EXAMPLE OF ADDRESS/MAILING LABELS │■│┌─────────────────────────────────────┐│■│ │■││ YELLOW REEDS STORE ││■│ │■││ HERMAN GREEN ││■│ │■││ 1234 RED LANE ││■│ │■││ SUITE BLUE 3 ││■│ │■││ WINTER PARK, FL 39393 ││■│ │■│└─────────────────────────────────────┘│■│ │■│┌─────────────────────────────────────┐│■│ │■││ EARL WOODS ││■│ │■││ PO BOX 3432-5555 ││■│ │■││ ORLANDO, FL 23434 ││■│ │■││ ││■│ │■││ ││■│ │■│└─────────────────────────────────────┘│■│ │■│┌─────────────────────────────────────┐│■│ KISBILL - Keep It Simple Billing and Invoicing System Page: 20 ■ FOLDER LABELS Use this option to print labels to attach atop manilla file folders. This option is the same as option 7, except that that different data is printed onto the label. The CUSNUM, NAME, PHONE, and CITY, STATE, ZIP are printed. ■ EXAMPLE OF A FOLDER LABEL │■│┌─────────────────────────────────────┐│■│ │■││ 50332 ││■│ │■││ HERMAN GREEN ││■│ │■││ 407-291-6987 ││■│ │■││ ORLANDO, FL 34323 ││■│ │■││ ││■│ │■│└─────────────────────────────────────┘│■│ │■│┌─────────────────────────────────────┐│■│ │■││ 8393 ││■│ │■││ EARL WOODS ││■│ │■││ 504-234-2303 ││■│ │■││ WINTER PARK, FL 34222 ││■│ │■││ ││■│ │■│└─────────────────────────────────────┘│■│ │■│┌─────────────────────────────────────┐│■│ ■ OPEN INVOICE REPORT This report is identical to option 1, except that it only prints out records (from the INVOICE.DBF) that have the OPEN field marked .T. *** Note that this report is 132 columns wide... ┌────[ Open Invoice Report (With Date Range & Index Selection) ]──────┐ │ Start Date: 10/12/89 │ │ End Date: 11/11/89 │ │ Select Index: 1 1-Invoice 2-Name 3-Cusnum │ │ Heading: TJS LAB │ │ Printer or File: 1 1-Printer 2-File │ │ │ └─────────────────────────────────────────────────────────────────────┘ KISBILL - Keep It Simple Billing and Invoicing System Page: 21 ■ SALES GRAPH Sales History Graph. This option will print onto the screen 2 reports. The first is a graph of the past 12 months of sales. The sum of each calendar month is calculated. DOES NOT INCLUDE any adjustments (ADJUST), freight (FREIGHT), or taxes. The data is derived solely from the PRICE*QTY (from the DETAIL.DBF), if not a deleted record. The second report is just the summary of the graph; a listing of each month, its total sales and numbers of items sold. To print either or both of these reports, just 'Print Screen'. The routine reindexes the DETAIL.DBF each time run (indexed on DATE). ■ GRAPH EXAMPLE #1 TJS LAB 11/05/89 SALES HISTORY, Past 12 Calendar Months ╔═══════════════════════════════════════════════════════════════════════╗ ║ ██▓▒░ ║ ║ ██▓▒░ ██▓▒░ ║ ║ ██▓▒░ ██▓▒░ ║ ║ ██▓▒░ ██▓▒░ ██▓▒░ ██▓▒░║ ║ ██▓▒░ ██▓▒░ ██▓▒░ ██▓▒░║ ║ ██▓▒░ ██▓▒░ ██▓▒░ ██▓▒░║ ║ ██$▒░ ██$▒░ ██$▒░ ██$▒░║ ║ $ ██1▒░ ██1▒░ $ ██1▒░ ██$▒░ ██1▒░║ ║ $ $ $ $ 2 ██2▒░ ██0▒░ 5 ██3▒░ ██7▒░ ██0▒░║ ║ 1 8 8 8 0 ██4▒░ ██8▒░ 2 ██3▒░ ██5▒░ ██8▒░║ ║ 0 3 3 $ 2 7 ██0▒░ ██2▒░ ██0▒░ ██4▒░ ██6▒░ ██4▒░║ ║ 0 5 2 9 5 0 ██8▒░ ██7▒░ ██2▒░ ██5▒░ ██7▒░ ██9▒░║ ║ 0 7 3 3 0 3 ██5▒░ ██3▒░ ██7▒░ ██7▒░ ██0▒░ ██6▒░║ ║ 0 1 1 3 2 5 ██0▒░ ██6▒░ ██1▒░ ██6▒░ ██2▒░ ██3▒░║ ║ . . . . . . ██.▒░ ██.▒░ ██.▒░ ██.▒░ ██.▒░ ██.▒░║ ║ 0 1 1 0 1 ██4▒░ ██0▒░ ██1▒░ ██3▒░ ██1▒░ ██4▒░ ██0▒░║ ║ 0▒░ ██6▒░ ██6▒░ 0▒░ ██6▒░ ██0▒░ ██0▒░ ██6▒░ ██2▒░ ██6▒░ ██6▒░ ██8▒░║ ╟─────┬─────┬─────┬─────┬─────┬─────┬─────┬─────┬─────┬─────┬─────┬─────╢ ║Dec88│Jan89│Feb89│Mar89│Apr89│May89│Jun89│Jul89│Aug89│Sep89│Oct89│Nov89║ ╚═════╧═════╧═════╧═════╧═════╧═════╧═════╧═════╧═════╧═════╧═════╧═════╝ Total Dollars YTD: $6,487,372.06 Total Pieces: 2255 KISBILL - Keep It Simple Billing and Invoicing System Page: 22 ■ GRAPH EXAMPLE #2 TJS LAB 11/05/89 SALES HISTORY, Past 12 Calendar Months ╔═══════════════════════════════════════════════════════════════════════╗ ║╔═[ Summary ]════════════════════════════════════════╗██▓▒░ ║ ║║ Month Year Total Sales Total Items║██▓▒░ ║ ║║ November 1989 $1,084,963.08 477 ║██▓▒░ ║ ║║ October 1989 $756,702.46 268 ║██▓▒░ ║ ║║ September 1989 $1,334,576.16 246 ║██▓▒░ ██▓▒░║ ║║ August 1989 $520,271.32 363 ║██▓▒░ ██▓▒░║ ║║ July 1989 $1,082,736.16 128 ║██▓▒░ ██▓▒░║ ║║ June 1989 $1,240,850.00 495 ║██$▒░ ██$▒░║ ║║ May 1989 $207,035.40 72 ║██1▒░ ██$▒░ ██1▒░║ ║║ April 1989 $82,502.16 27 ║██3▒░ ██7▒░ ██0▒░║ ║║ March 1989 $933.00 9 ║██3▒░ ██5▒░ ██8▒░║ ║║ February 1989 $83,231.16 30 ║██4▒░ ██6▒░ ██4▒░║ ║║ January 1989 $83,571.16 40 ║██5▒░ ██7▒░ ██9▒░║ ║║ December 1988 $10,000.00 100 ║██7▒░ ██0▒░ ██6▒░║ ║╚════════════════════════════════════════════════════╝██6▒░ ██2▒░ ██3▒░║ ║ . . . . . . ██.▒░ ██.▒░ ██.▒░ ██.▒░ ██.▒░ ██.▒░║ ║ 0 1 1 0 1 ██4▒░ ██0▒░ ██1▒░ ██3▒░ ██1▒░ ██4▒░ ██0▒░║ ║ 0▒░ ██6▒░ ██6▒░ 0▒░ ██6▒░ ██0▒░ ██0▒░ ██6▒░ ██2▒░ ██6▒░ ██6▒░ ██8▒░║ ╟─────┬─────┬─────┬─────┬─────┬─────┬─────┬─────┬─────┬─────┬─────┬─────╢ ║Dec88│Jan89│Feb89│Mar89│Apr89│May89│Jun89│Jul89│Aug89│Sep89│Oct89│Nov89║ ╚═════╧═════╧═════╧═════╧═════╧═════╧═════╧═════╧═════╧═════╧═════╧═════╝ Total Dollars YTD: $6,487,372.06 Total Pieces: 2255 KISBILL - Keep It Simple Billing and Invoicing System Page: 23 ■ CONFIGURATION This routine defines your company name, address, telephone number, invoice settings, printer settings, screen fonts. Other options allow you to view your system data, set color & intensity, and read/view the user manual. KISBILL V2.1, Copyright (c), 1989, 1990 TJS LAB ┌──[September 1990]──┐ ╔════════════════════════╗ │S M T W T F S │ ╓║ CONFIGURATION ║╖ ├────────────────────┤ ║╟────────────────────────╢║ │ 1│ ╟║ Company Name ║╢ Time: 17:44:55 │ 2 3 4 5 6 7 8│ ║║ Company Address ║║ │ 9 10 11 12 13 14 15│ ╟║ Company Telephone ║╢ Drive: D: │16 17 18 19 20 21 22│ ║║ Printer Driver/Setup ║║ │23 24 25 26 27 28 29│ ╟║ Last Invoice Number ║╢ Disk Size: 31,950,848 │30 │ ║║ Invoice Printer Type ║║ └────────────────────┘ ╟║ Invoice Printer Port ║╢ Available: 1,861,632 ║║ Default Tax Rate ║║ ╚║ Default Comment ║╝ ║ Screen Font ║▄██████▄ █▄███████░ ████░ ██░ ██░ ║ Read User Manual ║██░ ██░ ██░ ██░ ██░ ██░ ║ System ║██░ ██░ ██░ ██░ ██░ ██░ ╟────────────────────────╢██░ ██░ ██░ ██░ ██░ ██░ ║ Select Option ║▀██████▄ █████████░ ██░ ██░ ██░ ╚════════════════════════╝ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ████░ ▀██████▀ █▀███████░ ████░ ██████░ ██████░ Keep It Simple Billing & Invoicing Esc (Exit To DOS) KISBILL Configuration Settings ■ CONFIGURATION SETTINGS LIST Company Name Default Comment Company Address Screen Font Company Telephone Read User Manual Printer Driver/Setup System Last Invoice Number Reindex Databases Invoice Printer Type Color Invoice Printer Port High Intensity Default Tax Rate KISBILL - Keep It Simple Billing and Invoicing System Page: 24 ■ COMPANY NAME Enter your company name as you want it printed onto the invoice. ╔══════════════════════════════[ COMPANY NAME ]══════════════════════════════╗ ║ Enter Your Company Name: TJS LAB ║ ╚════════════════════════════════════════════════════════════════════════════╝ ■ COMPANY ADDRESS Enter your company address as you want it printed onto the invoice. ╔════════════════════════════[ COMPANY ADDRESS ]═════════════════════════════╗ ║ Address Line 1: Attn: Accounts Receivable ║ ║ Address Line 2: P.O. BOX 533466 ║ ║ City, State ZIP: Maitland, FL 32458-5366 ║ ╚════════════════════════════════════════════════════════════════════════════╝ ■ COMPANY TELEPHONE Enter your company telephone number as you want it printed onto the invoice. ╔═══════════════════════════[ COMPANY TELEPHONE ]════════════════════════════╗ ║ Enter Your Company Telephone: 407-291-3960 ║ ╚════════════════════════════════════════════════════════════════════════════╝ KISBILL - Keep It Simple Billing and Invoicing System Page: 25 ■ PRINTER DRIVER (SETUP) This routine was added to preclude you from having to get out of your seat to change the printer settings. The most important printer selections (ie: font size, lines per inch, orientation, ...) are made easy to evoke. ╔════════════════════════════════════════════════════════════════════════════╗ ║ █▄██░█▄██░███░█░ █░█████░███░█▄██░ █▄██▄ █▄██░███░█░ █░███░█▄██░ ║ ║ █░ █░█░ █░ █░ ██░ █░ █░ █░ █░ █░ █░ █░█░ █░ █░ █░ █░█░ █░ █░ ║ ║ █▀██░████░ █░ ███░█░ █░ ██░ ████░ █░ █░████░ █░ █▄ ▄█░██ ████░ ║ ║ █░ █░█░ █░ █░███░ █░ █░ █░█░ █░ █░█░█░ █░ █░█░ █░ █░█░ ║ ║ █░ █░▀█░ █░ █░ ██░ █░ █░ █░▀█░ █░ █░█░▀█░ █░ █▄█░ █░ █░▀█░ ║ ║ █░ █░ █░███░█░ █░ █░ ███░█░ █░ █▀██▀ █░ █░███░ █░ ███░█░ █░ ║ ║ ║ ║ Select Option -> Eject ║ ║ Line feed ║ ║ Normal Size ║ ║ Use this routine to set your Small/Condensed ║ ║ printer up with one or more Bold On ║ ║ of the setup strings and Bold Off ║ ║ commands listed to the right. 6 Lines per Inch ║ ║ 8 Lines per Inch ║ ║ Select the 'Change Printer Print Landscape (Laser Only) ║ ║ Default' option to change Print Portrait (Laser Only) ║ ║ printer types. Reset Printer ║ ║ Current printer is set to: Print Special String 1 ║ ║ Okidata Print Special String 2 ║ ║ Print Special String 3 ║ ╚════════════════════════════════════════════════════════════════════════════╝ Esc (Exit) ■ PRINTER DRIVER OPTIONS There are 18 printer driver options to select from. The last option is to set the default printer, and the next to last is a 'SHELL' function that runs a DOS command or program. The remainder are strings/codes that are sent to the printer. Eject Print Portrait (Laser Only) Line feed Reset Printer Normal Size Print Special String 1 Small/Condensed Print Special String 2 Bold On Print Special String 3 Bold Off Print Special String 4 6 Lines per Inch Print Special String 5 8 Lines per Inch Run DOS Command/Program Print Landscape (Laser Only) Change Default Printer KISBILL - Keep It Simple Billing and Invoicing System Page: 26 ■ CHANGE DEFAULT PRINTER The last option is to change/set the default printer. This printer driver routine comes with 4 default printer types, Epson, HP Laser, Star, and Okidata. You can add (Ctrl N) as many as you want. ╔════════════════════════════════════════════════════════════════════════════╗ ║ █▄██░█▄██░███░█░ █░█████░███░█▄██░ █▄██▄ █▄██░███░█░ █░███░█▄██░ ║ ║ █░ █░█░ █░ █░ ██░ █░ █░ █░ █░ █░ █░ █░█░ █░ █░ █░ █░█░ █░ █░ ║ ║ █▀██░████░ █░ ███░█░ █░ ██░ ████░ █░ █░████░ █░ █▄ ▄█░██ ████░ ║ ║ █░ █░█░ █░ █░███░ █░ █░ █░█░ █░ █░█░█░ █░ █░█░ █░ █░█░ ║ ║ █░ █░▀█░ █░ █░ ██░ █░ █░ █░▀█░ █░ █░█░▀█░ █░ █▄█░ █░ █░▀█░ ║ ║ █░ █░ █░███░█░ █░ █░ ███░█░ █░ █▀██▀ █░ █░███░ █░ ███░█░ █░ ║ ╟────────────────────────────────────────────────────────────────────────────╢ ║ Current Default Printer is set to: Okidata ║ ╟────────────────────────────────────────────────────────────────────────────╢ ║ NAME LINEFEED ║ ║─────────────────────────────────────╥──────────────────────────────────────║ ║ Epson & Compatibles ║ CHR(10) ║ ║ HP Laser & Compatibles ║ CHR(10) ║ ║ Star Micro Gemini ║ CHR(10) ║ ║ Okidata ║ CHR(10) ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ╚════════════════════════════════════════════════════════════════════════════╝ Esc (Exit) Enter/Return (Make Default) F2 (Edit) Ctrl N (Add) KISBILL - Keep It Simple Billing and Invoicing System Page: 27 ■ FULL SCREEN EDIT - F2 When entering the printer codes, the string must be in the valid format or it will not be printed later when requested... ┌───────────[ EDIT PRINTER DRIVER SETUP CODES - FULL SCREEN EDIT ]───────────┐ │ NAME: Epson & Compatibles │ │ LINEFEED: CHR(10) │ │ NORMAL: CHR(27)+CHR(18) │ │ SMALL: CHR(27)+CHR(15) │ │ BOLDON: CHR(27)+CHR(69) │ │ BOLDOFF: CHR(27)+CHR(70) │ │ _6LPI: CHR(27)+CHR(50) │ │ _8LPI: CHR(27)+CHR(48) │ │ PORTRAIT: │ │ LANDSCAPE: │ │ RESET: CHR(27)+CHR(64) │ │ SPEC_STR1: │ │ SPEC_STR2: │ │ SPEC_STR3: │ │ SPEC_STR4: │ │ SPEC_STR5: │ │ RUN_CMD: │ │ │ │ │ └────────────────────────────────────────────────────────────────────────────┘ Press Esc to Abort, PgUp/PgDn to Save and Exit ■ PRINTER DRIVER DATABASE FIELD DEFINITIONS NAME - Name of printer. Type in anything you wish here LINEFEED - Code to advance printer one line NORMAL - Normal font/character size SMALL - Small font/character size BOLDON - Bold/Emphasized BOLDOFF - Bold/Emphasized off _6LPI - Code to set printer to print 6 lines per inch _8LPI - Code to set printer to print 8 lines per inch PORTRAIT - Code to set lazer printer to print upright (normal) LANDSCAPE - Code to set lazer printer to print sideways RESET - Reset printer code SPEC_STR1 - Any special printer string, ie: print double, skip perforation, SPEC_STR2 - print very tiny, ... SPEC_STR3 - " SPEC_STR4 - " SPEC_STR5 - " RUN_CMD - DOS command or program, ie: CAPTURE p0 nff,SPOOL ON, ... KISBILL - Keep It Simple Billing and Invoicing System Page: 28 ■ LAST INVOICE NUMBER The invoice numbers start at this 'Last Invoice #' value + 1. The default is to have a first invoice number of '1'. ┌──────────────────────────[ LAST INVOICE NUMBER ]───────────────────────────┐ │ Enter Last Invoice Number: 112 │ └────────────────────────────────────────────────────────────────────────────┘ ■ PRINTER TYPE This option wants to know what type of printer you are using. The only difference between the two is that if you select the HP Laser option, you will be prompted to select the number of copies each time you print an invoice. Of course the HP Laser invoice is much prettier... ┌──────────────────────────────[ PRINTER TYPE ]──────────────────────────────┐ │ Invoice type can be in a standard or laser format. │ │ The STANDARD printer type is a Epson/IBM Proprinter compatible printer. │ │ The LASER printer type is a Hewlett Packard Laser compatible printer. │ │ Special Laser codes are sent to the LASER option. │ │ │ │ Enter Your Laser Printer Type -> STANDARD │ │ LASER │ └────────────────────────────────────────────────────────────────────────────┘ ■ INVOICE PRINTER PORT Select a valid printer port (1, 2 or 3). Note, most printers are LPT1, so you will probably select '1' as the invoice printer port. ┌──────────────────────────[ INVOICE PRINTER PORT ]──────────────────────────┐ │ Enter Your Report Printer Port (1,2,3): 1 │ └────────────────────────────────────────────────────────────────────────────┘ ■ DEFAULT TAX RATE The next prompt is for the default sales tax. The default is 6% (as in Florida). At invoice time, the default is to charge tax. ┌────────────────────────────[ DEFAULT TAX RATE ]────────────────────────────┐ │ Enter Your Default Tax Rate: 0.00000 │ └────────────────────────────────────────────────────────────────────────────┘ KISBILL - Keep It Simple Billing and Invoicing System Page: 29 ■ DEFAULT COMMENT This phrase is printed onto the invoice. It can be edited/changed during the invoicing process though. ┌────────────────────────────[ DEFAULT COMMENT ]─────────────────────────────┐ │ This comment is printed onto every Invoice. │ │ │ │ Enter Default Comment: Thank You Mary │ └────────────────────────────────────────────────────────────────────────────┘ ■ SCREEN FONTS Screen fonts are for computers supporting an EGA or VGA video card and monitor. Select 1 of 18 fonts for your computer screen. Note, the font will remain loaded until you reboot the computer or run another program that resets the screen to its default settings. Upon entering KISBILL, the font will reset the screen font to the selected one automatically. ╔═══[ SCREEN FONTS ]═══════════════════════════╗ ║ ║ ║ Select Font -> Standard (Normal) ║ ║ Old English ║ ║ Avante Garde ║ ║ Bauhaus ║ ║ Bodoni ║ ║ Esc (Exit) Broadway ║ ║ Script I ║ ║ Script II ║ ║ Calligraphy ║ ║ Garamond ║ ║ Legend ║ ║ Percy ║ ║ Park Avenue ║ ║ ║ ╚══════════════════════════════════════════════╝ Esc (Exit To DOS) KISBILL Configuration Settings ■ SCREEN FONTS LIST Standard (Normal) Garamond Old English Legend Avante Garde Percy Bauhaus Park Avenue Bodoni Computer Broadway Italic I Script I Italic II Script II Digital Calligraphy Romany KISBILL - Keep It Simple Billing and Invoicing System Page: 30 ■ READ USER MANUAL Use this option to view/read the documentation & user manual for KISBILL. Use the arrow and/or page up/down keys to navigate the document. Press Alt S to find a word or phrase, or F1 for a more detailed help description. ╒════════════════════════════════════════════════════════════════════════════╕ │ 39 ................Order Form │ │ KISBILL - Keep It Simple Billing and Invoicing System Page 23│ │ │ │ │ │ KISBILL.EXE Copyright (c) 1989 TJS LAB │ │ │ │ │ │ KISBILL is a simple to use and operate billing and invoicing system. Thi│ │product was produced to provide a means of billing a client or customer. Ver│ │little setup is required (ie: Your Company Name, and address). KISBILL utili│ │2 Dbase (tm) compatible databases which contain the invoice header and detai│ │data. The detail database also serves as an inventory/lookup file for later │ │invoices. KISBILL is also multi-user, able to operate on most of the PC base│ │networks, ie: Novell (tm). A simple database management module is also inclu│ │to provide you with additional means to modify, view or report on your data.│ │ │ │ │ │ Feature Highlights: │ │════════════════════════════════════════════════════════════════════════════│ │KISBILL.DOC │KISBILL.DOC │ │ │ │ │ │ ╘════════════════════════════════════════════════════════════════════════════╛ KISBILL - Keep It Simple Billing and Invoicing System Page: 31 ■ SYSTEM This option will display information about your computer onto the screen. Also it allows you to change the system time and date. Note, this time and date change may not work on all networks... ╔═════════════════════════════════[ SYSTEM ]════════════════════════════════╗ ║ DOS Version: 3.310 ║ ║ DOS Memory: 640 ║ ║ Free DOS Memory: 41,888 ║ ║ Extended Memory: 0 ║ ║ Expanded Memory: 0 ║ ║ Parallel Ports: LPT1: ║ ║ Serial Ports: COM1: COM2: ║ ║ CPU Type: 80286 ║ ║ Monitor Type: VGA ║ ║ Available Drives: ABCDE ║ ║ Current Drive: D: ║ ║ Volume Name: ║ ║ Disk Size: 31,950,848 ║ ║ Available Space: 1,845,248 5.78% of Disk Open... ║ ║ Disk Clusters: 15,601 ║ ║ Cluster Size: 2,048 ║ ║ Sectors: 4 ║ ║ Sector Size: 512 ║ ║ Date: 09/18/90 ║ ║ Time: 19:54:42 ║ ║ Change Date and/or Time? (Y/N) ║ ╚═══════════════════════════════════════════════════════════════════════════╝ Esc (Exit To DOS) ■ REINDEX DATABASES Should the need arise during the day to reindex the databases, or you suspect that the indexes are corrupted, use this option to recreate the indexes for databases: INVOICE.DBF & DETAIL.DBF. A progress graph of the indexing is displayed... ┌──────────────────────────────────────────────────────────┐ │ Database Name: invoice.DBF │ │ Index Name: name.NTX │ │ Number of Records: 19 │ │ ┌──────────────────────────────────────────────────┐ │ │ │████████████████████████████ │ │ │ └──────────────────────────────────────────────────┘ │ │ 0 ─ 10 ─ 20 ─ 30 ─ 40 ─ 50 ─ 60 ─ 70 ─ 80 ─ 90 ─ 100 % │ └──────────────────────────────────────────────────────────┘ KISBILL - Keep It Simple Billing and Invoicing System Page: 32 ■ COLOR MONITOR If you have a color monitor and wish to display colors, then select Y (YES), else select N (NO) for monochrome. The default is color, low intensity. ╔═════════════════════════════[ COLOR MONITOR ]══════════════════════════════╗ ║ If you have a color monitor and wish to display colors, then select Y, ║ ║ (YES), else select N (NO) for monochrome and others. ║ ║ The default is color, high intensity ║ ║ ║ ║ Do you have a color monitor? (Y/N) ║ ╚════════════════════════════════════════════════════════════════════════════╝ ■ COLOR INTENSITY If you have a color monitor and want high intensity (bright) colors, select Y for the high intensity. Default is high intensity. ╔════════════════════════════[ COLOR INTENSITY ]═════════════════════════════╗ ║ Intensity is only applicable with color set to Y. ║ ║ It will make your colors brighter... ║ ║ ║ ║ Set Color Intensity On? (Y/N) ║ ╚════════════════════════════════════════════════════════════════════════════╝ KISBILL - Keep It Simple Billing and Invoicing System Page: 33 ■ MISCELLANEOUS ROUTINES The MISC routines is a collection of 17 very useful Database Management Routines. These routines provide you with the 'ability to do whatever was left out of the rest of the program...'. These routines were modeled after dBase (tm) III+/IV functions. Familiarity with dBase will help with the understanding and execution of these routines. USE WITH CAUTION! YOU CAN ENHANCE AND CUSTOMIZE YOUR PROGRAM WITH THESE ROUTINES YOU CAN ALSO MESS THINGS UP PERMANENTLY! ■ MISC ROUTINES MENU: KISBILL V2.1, Copyright (c), 1989, 1990 TJS LAB ┌──[September 1990]──┐ ╔════════════════════╗ │S M T W T F S │ ║ MISC ROUTINES ║─────╖ ├────────────────────┤ ╟────────────────────╢ices ║ │ 1│ ║ APPEND FROM ║─────╢ Time: 17:44:47 │ 2 3 4 5 6 7 8│ ║ BROWSE DATABASES ║╔═══════════════════════╗ │ 9 10 11 12 13 14 15│ ║ COPY (.DBF) TO ║║Any changes to the ║ │16 17 18 19 20 21 22│ ║ CREATE DATABASE ║║databases: INVOICE.DBF ║ │23 24 25 26 27 28 29│ ║ DELETE RECORDS ║║and/or DETAIL.DBF WILL ║,848 │30 │ ║ ERASE FILE ║║corrupt their indexes, ║ └────────────────────┘ ║ EXIT TO DOS ║║and WILL require a ║632 ║ INDEX A DATABASE ║║Reindexing! Reindex ║ ║ LIST FIELDS ║║both databases from the║ ║ PACK DATABASE ║║Configuration Menu... ║█░ ████░ ██░ ██░ ║ MODIFY DATABASE ║╚═══════════════════════╝██░ ██░ ██░ ██░ ║ RECALL RECORDS ║░ ██░ ██░ ██░ ██░ ██░ ██░ ║ RETURN TO MENU ║░ ██░ ██░ ██░ ██░ ██░ ██░ ║ RUN (DOS COMMAND) ║░ ▀██████▄ █████████░ ██░ ██░ ██░ ║ SIMPLE EDITOR ║░ ██░ ██░ ██░ ██░ ██░ ██░ ║ SORT DATABASE ║░ ██░ ██░ ██░ ██░ ██░ ██░ ║ TYPE (PRINT) FILE ║░ ██░ ██░ ██░ ██░ ██░ ██░ ║ ZAP DATABASE ║█░ ▀██████▀ █▀███████░ ████░ ██████░ ██████░ ╟────────────────────╢ Keep It Simple Billing & Invoicing ║ Select Option ║ ╚════════════════════╝ Database Management Routines KISBILL - Keep It Simple Billing and Invoicing System Page: 34 ■ APPEND FROM Used to copy records from one database into another database, or to create records from ASCII files (SDF or DELIMITED). The Initial Screen will prompt you to enter the file name of the database you are to append/copy the data into. At this point, you can either type in the name of the target database, or ... ┌──────────────────────────────[ APPEND FROM ]───────────────────────────────┐ │ Enter Database Name To Append Data Into: │ │ Enter Nothing For Listing Of Current Directory... │ └────────────────────────────────────────────────────────────────────────────┘ If it exists in the current directory, press enter on an empty prompt to display all databases to select from. ┌──────────────────────────────[ APPEND FROM ]──────────────────────────────┐ │ │ │ Enter Database Name To Append Data Into: │ │ Enter┌────────[ PICK A DATABASE ]───────────┐y... │ │ │ FILE NAME SIZE DATE USED│ │ │ ├──────────────┬────────────┬──────────┤ │ │ │INVENT.DBF │ 375 │ 09/16/89 │ │ │ │AR.DBF │ 7219 │ 09/16/89 │ │ │ │HISTORY.DBF │ 103 │ 09/16/89 │ │ │ │PERSONS.DBF │ 24271 │ 09/16/89 │ │ │ │CUSTOMER.DBF │ 289 │ 09/16/89 │ │ │ └──────────────┴────────────┴──────────┘ │ │ ┌───────────────────────┐│ │ │ Highlight a database ││ │ │ using the ││ │ │ arrow keys, then press││ │ │ Enter/Return. ││ │ └───────────────────────┘│ │ │ └───────────────────────────────────────────────────────────────────────────┘ The next prompt will be to select the type of Append: ┌──────────────────────────────[ APPEND FROM ]─────────────────────────────┐ │ │ │ Enter Database Name To Append Data Into: │ │ Enter Nothing For Listing Of Current Directory... │ │ │ │ Append Data Into INVENT.DBF │ │ │ │ Type of Append: Standard SDF DELIMITED │ │ │ └──────────────────────────────────────────────────────────────────────────┘ KISBILL - Keep It Simple Billing and Invoicing System Page: 35 If you are appending from another database (.DBF) then select 'Standard'. Select the SDF option if you are appending from a 'flat' ASCII file. Select the DELIMITED option if you are appending from a delimited ASCII file. Delimited files contain records in which the fields are separated by commas, and its character fields contained in double quotes... If you select a Standard Append, you will then be prompted to enter the name of the database you wish to get the data from. If you selected the SDF or DELIMITED options, then enter the file name containing the data to be appended into your target database. ┌──────────────────────────────[ APPEND FROM ]─────────────────────────────┐ │ │ │ Enter Database Name To Append Data Into: │ │ Enter Nothing For Listing Of Current Directory... │ │ │ │ Append Data Into PERSONS.DBF │ │ │ │ Type of Append: Standard SDF DELIMITED │ │ │ │ Enter Database Name To Append Data FROM: PERSON1.TXT │ │ │ │ │ └──────────────────────────────────────────────────────────────────────────┘ The number of records appended into the target database will be displayed upon completion of the task... ┌──────────────────────────────[ APPEND FROM ]───────────────────────────────┐ │ │ │ Enter Database Name To Append Data Into: │ │ Enter Nothing For Listing Of Current Directory... │ │ │ │ Append Data Into INVENT.DBF From INVENTY.DBF │ │ │ │ Type of Append: Standard SDF DELIMITED │ │ │ │ Enter Database Name To Append Data FROM: INVENTY.DBF │ │ │ │ │ │ │ │ There Were 1 Records Appended Into INVENT.DBF │ │ │ │ │ │ │ │ Press Any Key To Continue... │ │ │ └────────────────────────────────────────────────────────────────────────────┘ KISBILL - Keep It Simple Billing and Invoicing System Page: 36 ■ BROWSE DATABASES Used to edit/view records in a database. Enter the database name you wish to edit/browse, or if it exists in the current directory, press enter on an empty prompt to bring up a window box to select from. ┌───────────────────────────────────────────────────────────────┐ │ Enter Database Name: INVENT.DBF │ │ │ └───────────────────────────────────────────────────────────────┘ If there exists an index (.NDX or .NTX), with the same name as the database, it will be utilized... An example of a browse screen: TJS LAB, PO BOX 585366 ┌────────────────────────────────[ BROWSE SDF ]──────────────────────────────┐ │ MFG_PART DESC PRICE LIST │ │──────────────────╥────────────────────────────────╥────────────╥───────────│ │ 19730 ║ DAYO CONFIGURATION SETTINGS ║ 896.16 ║ 1792.32 │ │ 23429 ║ DAYO CUSTOMER ║ 1064.19 ║ 2128.38 │ │ 14797 ║ DAYO END OF PERIOD/DAY ║ 672.12 ║ 1344.24 │ │ 38227 ║ DAYO FINANCE,PERSONNEL,PAYROLL ║ 1736.31 ║ 3472.62 │ │ 11098 ║ DAYO INVENTORY ║ 504.09 ║ 1008.18 │ │ 17264 ║ DAYO MISC ROUTINES ║ 784.14 ║ 1568.28 │ │ 30828 ║ DAYO PICK, INVOICING ║ 1400.25 ║ 2800.50 │ │ 35760 ║ DAYO PURCHASE ORDERS ║ 1624.29 ║ 3248.58 │ │ 25896 ║ DAYO QUOTES ║ 1176.21 ║ 2352.42 │ │ 62889 ║ DAYO ROPA ║ 2856.51 ║ 5713.02 │ │ 64122 ║ DAYO ROPA/ROPC SOURCE ║ 2912.52 ║ 5825.04 │ │ 28362 ║ DAYO SALES ORDERS, P.O.S. ║ 1288.23 ║ 2576.46 │ │ 33294 ║ DAYO VENDORS ║ 1512.27 ║ 3024.54 │ │ 66588 ║ DBASE TRAINING (PER HOUR) ║ 3024.54 ║ 6049.08 │ │ 16031 ║ EOP SOURCE ║ 728.13 ║ 1456.26 │ │ 49325 ║ EXPENSES SOURCE ║ 2240.40 ║ 4480.80 │ │ 39460 ║ FINANCE SOURCE ║ 1792.32 ║ 3584.64 │ ├──────────────────╨────────────────────────────────╨────────────╨───────────┤ │ Esc(EXIT) Ctrl N(ADD) Ctrl U(DELETE) F5(Find) │ └────────────────────────────────────────────────────────────────────────────┘ 51/60 KISBILL - Keep It Simple Billing and Invoicing System Page: 37 To edit a memo field, just highlight the field, and start typing. * * * To save your work, once finished, YOU MUST PRESS Ctrl W UPON EXITING! ┌────────────────────────────────[ BROWSE SDF ]──────────────────────────────┐ │ PRICE LIST YOURPART NOTES │ │───────────────────────╥────────────╥─────────────────╥─────────────────────│ │ 896.16 ║ 1792.32 ║ ║ <Memo> │ │ 1064.19 ║ 2128.38 ║ ║ <Memo> │ │ 672.12 ║ 1344.24 ║ ║ <Memo> │ │ 1736.31 ║ 3472.62 ║ ║ <Memo> │ │ 504.09 ║ 1008.18 ║ ║ <Memo> │ │ 784.14 ║ 1568.28 ║ ║ <Memo> │ │ 1400.25 ║ 2800.50 ║ ║ <Memo> │ ┌────────────────────────────[ Edit Field: NOTES ] ──────────────────────────┐ │You can edit memo fields too... │ │ │ │ │ │ │ │ │ │ │ │ │ └───────────────────────[ Esc (ABORT) Ctrl W (SAVE) ]─────────────────────┘ │ Esc(EXIT) Ctrl N(ADD) Ctrl U(DELETE) F5(Find) │ └────────────────────────────────────────────────────────────────────────────┘ Special keys for 'moving around' the BROWSE screen are: Left Arrow Key - Move to next field to your left Right Arrow Key - Move to next field to your right Ctrl Home - Go to the leftmost field Ctrl End - Go to the rightmost field (on the end of the record) Up Arrow - Move highlight to the previous record Down Arrow - Move highlight to the next record PgUp - Page up a full screen of records PgDn - Page down a full screen of records Ctrl PgUp - Go to the beginning of the file Ctrl PgDn - Go to the end or last record of the file Ctrl N - Add a record (where applicable) Ctrl U - Delete a record (where applicable) F5 - To seek/find a record based upon the active index Esc - Exit the current operation Remember that there are many more fields to the right of the screen. Press the right arrow key to view them... KISBILL - Keep It Simple Billing and Invoicing System Page: 38 ■ COPY (.DBF) TO Copy records to another (new) database. Use this option to copy select records into a new database or ASCII (SDF and DELIMITED) file. COPY TO can also be used to create backups of data (IE: copy to floppy). ┌─────────────────────────────[ COPY (.DBF) TO ]─────────────────────────────┐ │ │ │ Enter Database Name To COPY FROM: │ │ Enter┌────────[ PICK A DATABASE ]───────────┐y... │ │ │ FILE NAME SIZE DATE USED│ │ │ ├──────────────┬────────────┬──────────┤ │ │ │HARPS.DBF │ 375 │ 09/16/89 │ │ │ │INVENT.DBF │ 7335 │ 09/16/89 │ │ │ │SDFSTUF.DBF │ 103 │ 09/16/89 │ │ │ │MORETRAH.DBF │ 24387 │ 09/16/89 │ │ │ │AP.DBF │ 289 │ 09/16/89 │ │ │ └──────────────┴────────────┴──────────┘ │ │ ┌───────────────────────┐│ │ │ Highlight a database ││ │ │ using the ││ │ │ arrow keys, then press││ │ │ Enter/Return. ││ │ └───────────────────────┘│ └────────────────────────────────────────────────────────────────────────────┘ The next prompt will be to select the type of COPY TO option you want: ┌──────────────────────────────[ COPY (.DBF) TO ]────────────────────────────┐ │ │ │ Enter Database Name To COPY FROM: INVENT.DBF │ │ Enter Nothing For Listing Of Current Directory... │ │ │ │ │ │ Type of Copy To: Standard SDF DELIMITED STRUCTURE │ │ │ │ │ │ Copy Records From INVENT.DBF │ └────────────────────────────────────────────────────────────────────────────┘ The Standard option is simply creating another database (.DBF). The SDF and DELIMITED options will create ASCII files. The STRUCTURE option creates a new database with the same file structure as the initial database (no records copied). KISBILL - Keep It Simple Billing and Invoicing System Page: 39 The next prompt (optional), requires some knowledge of dBase (tm). This prompt is requesting the user to to enter a condition or filter. If all records are to be copied, just press Enter on an empty prompt. ┌╔═══════════════════════════[ FIELD NAMES & TYPE ]═════════════════════════╗┐ │║ ║│ │║PART{C} ■ MFG_PART{C} ■ DESC{C} ■ PRICE{N} ■ LIST{N} ■ YOURPART{C} ■ ║│ │║NOTES{M} ■ ║│ │╚══════════════════════════════════════════════════════════════════════════╝│ │ │ │ │ │ Type of Copy To: Standard SDF DELIMITED STRUCTURE │ │ │ │ Enter SDF File Name To Copy Data TO: NEW.DBF │ │ │ │ Enter Condition: │ │ Sample condition: COST > 100 │ │ │ │ │ │ Copy Records From NEW │ └────────────────────────────────────────────────────────────────────────────┘ This 'Condition' option is useful for coping only specific records into a new location. Any valid dBase/Clipper statement (as shown next) is fine... ┌╔═══════════════════════════[ FIELD NAMES & TYPE ]═════════════════════════╗┐ │║ ║│ │║PART{C} ■ MFG_PART{C} ■ DESC{C} ■ PRICE{N} ■ LIST{N} ■ YOURPART{C} ■ ║│ │║NOTES{M} ■ ║│ │╚══════════════════════════════════════════════════════════════════════════╝│ │ │ │ Type of Copy To: Standard SDF DELIMITED STRUCTURE │ │ │ │ Enter SDF File Name To Copy Data TO: NEW DBF │ │ │ │ Enter Condition: PRICE>0 │ │ Sample condition: COST > 100 │ │ │ │ Copy Records From NEW │ └────────────────────────────────────────────────────────────────────────────┘ KISBILL - Keep It Simple Billing and Invoicing System Page: 40 The following window message will appear while the COPY TO routine does its task: ┌╔═══════════════════════════[ FIELD NAMES & TYPE ]═════════════════════════╗┐ │║ ║│ │║PART{C} ■ MFG_PART{C} ■ DESC{C} ■ PRICE{N} ■ LIST{N} ■ YOURPART{C} ■ ║│ │║NOTES{M} ■ ║│ │╚══════════════════════════════════════════════════════════════════════════╝│ │ │ │ Type of Copy To: Standard SDF DELIMITED STRUCTURE │ │ │ │ Enter SDF File Name To Copy Data TO: NEW10 │ │ │ │ Enter Condition: PRICE>0 │ │ Sample cond┌───────────────────────────────────────────────┐ │ │ │┌─────────────────────────────────────────────┐│ │ │ CONDITION: ││┌───────────────────────────────────────────┐││ │ │ │││┌─────────────────────────────────────────┐│││ │ │ ││││Hold those camels while I do this COPY TO││││ │ │ │││└─────────────────────────────────────────┘│││ │ │ ││└───────────────────────────────────────────┘││ │ │ │└─────────────────────────────────────────────┘│ │ │ └───────────────────────────────────────────────┘ │ │ Copy Records From SDF To NEW10 │ └────────────────────────────────────────────────────────────────────────────┘ ■ CREATE DATABASE Create a new database. This routine lets you create entirely new database structures. At the FIELD_NAME field, enter a unique field name. At the FIELD_TYPE field, enter a 'C' for character, 'N' for numeric, 'D' for Date, 'L' for logical or 'M' for memofield. At the FIELD_LEN field, enter the size/length of the character and/or numeric field. At the FIELD_DEC field, enter the number of decimals for the numeric field. ┌───────[ CREATE A NEW DATABASE: NEW.DBF ]────────┐ │ FIELD_NAME FIELD_TYPE FIELD_LEN FIELD_DEC │ │────────────╥────────────╥───────────╥───────────│ │ ║ ║ 0 ║ 0 │ │ ║ ║ ║ │ │ ║ ║ ║ │ ┌─────────────│ ║ ║ ║ │────────────┐ │ │ ║ ║ ║ │ │ │ ENTER TH│ ║ ║ ║ │ │ │ │ ║ ║ ║ │ │ └─────────────│ ║ ║ ║ │────────────┘ │────────────╨────────────╨───────────╨───────────│ │ Press Enter to edit any field... │ └──────[ PRESS Ctrl W TO SAVE AND EXIT ]────────┘ KISBILL - Keep It Simple Billing and Invoicing System Page: 41 * * * TO EDIT ANY FIELD, YOU MUST PRESS Enter FIRST * * * IT IS SLIGHTLY BOTHERSOME SORRY! WANT YOU TO THINK ABOUT WHAT YOU ARE DOING... *** If any error is made in this routine, you will experience an error, either immediately, or when you start to edit the new database. This error may even cause your computer to hang! *** Be sure to Press: Ctrl W when you are finished and satisfied. Pressing Esc will just negate your efforts.. ┌───────[ CREATE A NEW DATABASE: NEW.DBF ]────────┐ │ FIELD_NAME FIELD_TYPE FIELD_LEN FIELD_DEC │ │────────────╥────────────╥───────────╥───────────│ │ NAME ║ C ║ 30 ║ 0 │ │ AGE ║ N ║ 5 ║ 1 │ │ DEAD ║ L ║ 1 ║ 0 │ │ BIRTHDATE ║ D ║ 8 ║ 0 │ ┌─────────────│ REMARKS ║ M ║ 10 ║ 0 │────────────┐ │ │ ║ ║ 0 ║ 0 │ │ │ ENTER TH│ ║ ║ ║ │ │ │ │ ║ ║ ║ │ │ │ │ ║ ║ ║ │ │ └─────────────│ ║ ║ ║ │────────────┘ │ ║ ║ ║ │ │────────────╨────────────╨───────────╨───────────│ │ Press Enter to edit any field... │ └──────[ PRESS Ctrl W TO SAVE AND EXIT ]────────┘ KISBILL - Keep It Simple Billing and Invoicing System Page: 42 ■ DELETE RECORDS Delete selected records from databases. The first prompt is for the name of the database you wish to mark records for deletion. Like many of the other routines, you can press enter on an empty prompt to bring up all databases that exist in the current directory: ┌────────[ PICK A DATABASE ]───────────┐ │ FILE NAME SIZE DATE USED│ ├──────────────┬────────────┬──────────┤ │D.DBF │ 259 │ 09/16/89 │ │DDD.DBF │ 375 │ 09/16/89 │ │NEW.DBF │ 195 │ 09/17/89 │ │SDF.DBF │ 7335 │ 09/16/89 │ │TRASH.DBF │ 24387 │ 09/16/89 │ │XXX.DBF │ 289 │ 09/16/89 │ ┌────────────────────────┐ └──────────────┴────────────┴──────────┘ │ Highlight a database │ │ using the │ ┌────────────────────────[ DELETE SELECTED RECORDS ]│ arrow keys, then press │ │ Enter Database Name: │ Enter/Return. │ │ └────────────────────────┘ │ │ └────────────────────────────────────────────────────────────────────────────┘ After selecting the database, all its fields will be presented atop the screen so as to aid the user in entering a condition/filter. The use of the condition prompt is NOT optional, so some knowledge of dBase/Clipper syntax is required. Note the use of the Clipper Function: EMPTY(). ╒╔═══════════════════════════[ FIELD NAMES & TYPE ]══════════════════════════╗ │║ ║ ╘║PART{C} ■ MFG_PART{C} ■ DESC{C} ■ PRICE{N} ■ LIST{N} ■ YOURPART{C} ■ ║ ║NOTES{M} ■ ║ ╚═══════════════════════════════════════════════════════════════════════════╝ ┌────────────────────────[ DELETE SELECTED RECORDS ]─────────────────────────┐ │ Enter Database Name: TRASH │ │ Delete Records For Condition: EMPTY(PART) │ │ Sample condition: COST > 100 │ │ CONDITION: EMPTY(PART) │ │ Number of Records Deleted: 208 │ │ Press any key to continue... │ └────────────────────────────────────────────────────────────────────────────┘ The number of records deleted will be displayed upon the screen as depicted just above... KISBILL - Keep It Simple Billing and Invoicing System Page: 43 ■ ERASE FILE Erase a file (forever!). Use this option with extreme care! Again, be careful! ANY FILE SELECTED WITH THIS OPTION WILL BE PERMANENTLY REMOVED FROM EXISTENCE NO SECOND CHANCES HERE... The first prompt is for the file name. You can press enter on an empty prompt to bring up a window selection of all files in the current directory. ┌────────────────────────┐ ┌────────[ ERASE THE FILE ]────────────┐ │ Highlight a file │ │ FILE NAME SIZE DATE USED│ │ using the │ ├──────────────┬────────────┬──────────┤ │ arrow keys, then press │ │B.BAT │ 222 │ 09/16/89 │ │ Enter/Return. │ │BKDOOR.$$$ │ 8192 │ 09/16/89 │ └────────────────────────┘ │BKDOOR.DOC │ 37029 │ 09/17/89 │ │BKDOOR.ZIP │ 19415 │ 09/16/89 │ │D.DBF │ 259 │ 09/16/89 │ │D.DBT │ 512 │ 09/16/89 │ │DAYOBK.BAK │ 36879 │ 09/16/89 │ │DAYOBK.LIB │ 36879 │ 09/16/89 │ │DAYOBK.LST │ 2056 │ 09/16/89 │ │DAYOBK.OBJ │ 35585 │ 09/16/89 │ │DAYOCAL.MAP │ 35 │ 09/16/89 │ │DDD.DBF │ 375 │ 09/16/89 │ │DDD.DBT │ 512 │ 09/16/89 │ │DDD.NTX │ 2048 │ 09/16/89 │ │DEMO.EXE │ 245404 │ 09/16/89 │ └──────────────┴────────────┴──────────┘ More * To ERASE a file, just highlight it, then press Enter... ■ EXIT TO DOS This option will close all open files and databases and exit to DOS without having to return to the main menu exit routine. KISBILL - Keep It Simple Billing and Invoicing System Page: 44 ■ INDEX A DATABASE You will be prompted to select the database you wish to index. After selecting the database, by typing in the name or pressing Enter on an empty prompt (then selecting from the window), you will be given a listing of all fields in that database atop the screen. ┌────────[ PICK A DATABASE ]───────────┐. │ FILE NAME SIZE DATE USED│ ├──────────────┬────────────┬──────────┤ │DAD.DBF │ 259 │ 09/16/89 │ │NEW.DBF │ 195 │ 09/17/89 │ │SPW.DBF │ 7335 │ 09/16/89 │ │SOW.DBF │ 103 │ 09/16/89 │ │BOY.DBF │ 24387 │ 09/17/89 │ │SHI.DBF │ 289 │ 09/16/89 │ ┌────────────────────────┐ └──────────────┴────────────┴──────────┘ │ Highlight a database │ │ using the │ ┌───────────────────[ INDEX A DATABASE ]───│ arrow keys, then press │ │ Enter Database Name: │ Enter/Return. │ │ └────────────────────────┘ └───────────────────────────────────────────────────────────────┘ You will now be prompted to enter the name of the Index File. It will be (by default), named exactly the same as the selected database, with the exception of the extension. This will default to .NDX or .NTX depending on whether you linked NDX.OBJ with your application. *** Remember that the BROWSE routine only looks at indexes with the same name as the database. ╒╔═══════════════════════════[ FIELD NAMES & TYPE ]══════════════════════════╗ │║ ║ ╘║PART{C} ■ MFG_PART{C} ■ DESC{C} ■ PRICE{N} ■ LIST{N} ■ YOURPART{C} ■ ║ ║NOTES{M} ■ ║ ╚═══════════════════════════════════════════════════════════════════════════╝ ┌───────────────────[ INDEX A DATABASE ]────────────────────────┐ │ Enter Name of Index File: TRASH.NTX │ └───────────────────────────────────────────────────────────────┘ KISBILL - Keep It Simple Billing and Invoicing System Page: 45 At the prompt for the index key, enter a field name, or a valid dBase/Clipper expression. ╒╔══════════════════════════[ FIELD NAMES & TYPE ]═══════════════════════════╗ │║ ║ ╘║PART{C} ■ MFG_PART{C} ■ DESC{C} ■ PRICE{N} ■ LIST{N} ■ YOURPART{C} ■ ║ ║NOTES{M} ■ ║ ╚═══════════════════════════════════════════════════════════════════════════╝ ┌───────────────────[ INDEX A DATABASE ]────────────────────────┐ │ Enter Name of Index File: TRASH.NTX │ │ Enter the Key Expression: PART+MFG_PART │ └───────────────────────────────────────────────────────────────┘ ■ LIST FIELDS List fields to screen or printer. This routine is a great tool for providing simple reports and lists. The first prompt will be for the database you wish to work with. Type the name of the file, or press Enter on an empty prompt to bring up a window of all databases in the current directory for selection. ┌────────[ PICK A DATABASE ]───────────┐ │ FILE NAME SIZE DATE USED│ ├──────────────┬────────────┬──────────┤ │INVEND.DBF │ 259 │ 09/16/89 │ │INVENT.DBF │ 375 │ 09/16/89 │ │NEW.DBF │ 195 │ 09/17/89 │ │SOMEDAY.DBF │ 7335 │ 09/16/89 │ │TANGO.DBF │ 103 │ 09/16/89 │ │AP.DBF │ 24387 │ 09/17/89 │ │BACKUP.DBF │ 289 │ 09/16/89 │ ┌────────────────────────┐ └──────────────┴────────────┴──────────┘ │ Highlight a database │ │ using the │ ┌──────────────────────────────────────────│ arrow keys, then press │ │ Enter Database Name: │ Enter/Return. │ │ └────────────────────────┘ └───────────────────────────────────────────────────────────────┘ KISBILL - Keep It Simple Billing and Invoicing System Page: 46 The next prompt is for a condition or filter. This makes it possible to list only specific records that meet that condition you enter. The condition must be a valid dBase/Clipper expression, or none (to list all). ╒╔══════════════════════════[ FIELD NAMES & TYPE ]═══════════════════════════╗ │║ ║ ╘║PART{C} ■ MFG_PART{C} ■ DESC{C} ■ PRICE{N} ■ LIST{N} ■ YOURPART{C} ■ ║ ║NOTES{M} ■ ║ ╚═══════════════════════════════════════════════════════════════════════════╝ ┌─────────────────────────────────────────────────────┐ │ Enter Filter: │ │ IE: ID = "SAM0909" .AND. RETAIL > 10000 │ └─────────────────────────────────────────────────────┘ ┌───────────────────────────────────────────────────────────────┐ │ Enter Database Name: │ │ │ └───────────────────────────────────────────────────────────────┘ A window box appears next displaying all the fields in the selected database and an option to list all fields. Highlight any combination of fields ( or ALL) that you want listed. ╒╔═┌─────────────────┐═══════[ FIELD NAMES & TYPE ]══════════════════════════╗ │║ │ PICK THE FIELDS │ ║ ╘║P│ YOU WANT LISTED │} ■ DESC{C} ■ PRICE{N} ■ LIST{N} ■ YOURPART{C} ■ ║ ║ ├─────────────────┤ ║ ╚═│■■ ALL ■■ │═══════════════════════════════════════════════════════╝ │RECNO() │ │MFG_PART │ │PRICE │ │YOURPART │ ┌────────────────────────────────────────────────────┐ │NOTES │ │ Enter Filter: │ ├─────────────────┤ │ EG: ID = "SAM0909" .AND. RETAIL > 10000 │ │PRESS Esc TO EXIT│ └────────────────────────────────────────────────────┘ └─────────────────┘────────────────────────────────────────────────────┐ │ Enter Database Name: │ └───────────────────────────────────────────────────────────────┘ KISBILL - Keep It Simple Billing and Invoicing System Page: 47 The fields you select will be displayed at center top of screen. Press Esc to exit the "PICK THE FIELDS YOU WANT LISTED" window. ╒╔═┌─────────────────┐═══════[ FIELD NAMES & TYPE ]══════════════════════════╗ │║ │ PICK THE FIELDS │ ║ ╘║P│ YOU WANT LISTED │} ■ DES┌────────────────────┐{N} ■ YOURPART{C} ■ ║ ║N├─────────────────┤ │PART │ ║ ╚═│■■ ALL ■■ │═══════│MFG_PART │══════════════════════════╝ │RECNO() │ │PRICE │ │PART │ └────────────────────┘ │PRICE │ │YOURPART │ ┌────────────────────────────────────────────────────┐ │NOTES │ │ Enter Filter: │ ├─────────────────┤ │ EG: ID = "SAM0909" .AND. RETAIL > 10000 │ │PRESS Esc TO EXIT│ └────────────────────────────────────────────────────┘ └─────────────────┘────────────────────────────────────────────────────┐ │ Enter Database Name: │ └───────────────────────────────────────────────────────────────┘ At the next prompt, you can send the list to the SCREEN, PRINTER OR FILE. ╒╔═┌─────────────────┐═══════[ FIELD NAMES & TYPE ]══════════════════════════╗ │║ │ PICK THE FIELDS │ ║ ╘║P│ YOU WANT LISTED │} ■ DES┌────────────────────┐{N} ■ YOURPART{C} ■ ║ ║N├─────────────────┤ │PART │ ║ ╚═│■■ ALL ■■ │═══════│MFG_PART │══════════════════════════╝ │RECNO() │ │PRICE │ │PART │ └────────────────────┘ │DESC┌──────────────────────────────────────────────────────────────────┐ │PRIC│ Do you want to print the list to the SCREEN or PAPER or FILE ? │ │LIST│ │ │YOUR└──────────────────────────────────────────────────────────────────┘─┐ │NOTES │ │ Enter Filter: │ ├─────────────────┤ │ EG: ID = "SAM0909" .AND. RETAIL > 10000 │ │PRESS Esc TO EXIT│ └────────────────────────────────────────────────────┘ └─────────────────┘────────────────────────────────────────────────────┐ │ Enter Database Name: │ └───────────────────────────────────────────────────────────────┘ KISBILL - Keep It Simple Billing and Invoicing System Page: 48 The list is very simple, and if displayed onto the screen, may look like the following: PART MFG_PART PRICE 4523 0.00 DAYO9S 41926 1904.34 DAYO10S 13564 616.11 DAYOCOMP 45625 2072.37 DAYOALLS 43159 1960.35 INDEXER 50558 2296.41 INDEXERS 51791 2352.42 5 DEMO 4932 224.04 DAYO13S 20963 952.17 MENUS 53024 2408.43 OFFSITEP 56724 2576.46 ONSITEP 57957 2632.47 DAYO2S 24662 1120.20 DAYO9 40693 1848.33 DAYO10 12331 560.10 DAYOCAL$ 44392 2016.36 DAYO13 19730 896.16 DAYO2 23429 1064.19 DAYO11 14797 672.12 DAYO8 38227 1736.31 DAYO1 11098 504.09 DAYO12 17264 784.14 DAYO5 30828 1400.25 ......PRESS ANY KEY TO CONTINUE...... ■ MODIFY DATABASE Change the fields/structure of a database. You can add new fields, delete fields, change the length and type of field in any of the databases. At the FIELD_NAME field, enter a unique field name. At the FIELD_TYPE field, enter a 'C' for character, 'N' for numeric, 'D' for Date, 'L' for logical or 'M' for memofield. At the FIELD_LEN field, enter the size/length of the character and/or numeric field. At the FIELD_DEC field, enter the number of decimals for the numeric field. ******************************************************** *** TO EDIT ANY FIELD, YOU MUST PRESS Enter FIRST *** *** IT IS SLIGHTLY BOTHERSOME SORRY! *** ******************************************************** *** If any error is made in this routine, you will experience an error, either immediately, or when you start to access the database. This error may even cause your computer to hang! KISBILL - Keep It Simple Billing and Invoicing System Page: 49 *** Be sure to Press: Ctrl W when you are finished and satisfied. Pressing Esc will just negate your efforts.. ■ PACK DATABASE Pack a database (removed deleted records). This option will permanently remove any records marked for deletion. This is another routine you should use with great care! As in many of the other of the routines, you will be prompted to enter the name of the database you wish to pack. Enter the name or press Enter on an empty prompt to view the window. ┌─────┐ │PACK!│ └─────┘ ┌────────[ PICK A DATABASE ]───────────┐ │ FILE NAME SIZE DATE USED│ ├──────────────┬────────────┬──────────┤ │GOODDATA.DBF │ 259 │ 09/16/89 │ │HAP.DBF │ 375 │ 09/16/89 │ │NEW.DBF │ 195 │ 09/17/89 │ │SDF.DBF │ 7335 │ 09/16/89 │ │LOIN.DBF │ 103 │ 09/16/89 │ │TRASH.DBF │ 24387 │ 09/17/89 │ │FIX.DBF │ 289 │ 09/16/89 │ ┌────────────────────────┐ └──────────────┴────────────┴──────────┘ │ Highlight a database │ │ using the │ ┌──────────────────────────────────────────│ arrow keys, then press │ │ Enter Database Name: │ Enter/Return. │ └──────────────────────────────────────────└────────────────────────┘ After selecting the database, you will be prompted to respond with a Yes or No (to Pack or not to Pack...). This is the last chance you have to change your mind... ┌──────────────────────────────────────────────────────────────────────────┐ │ PACK TOM3 │ │ Are you sure you want to PACK (remove deleted records) ? N │ └──────────────────────────────────────────────────────────────────────────┘ │ Enter Database Name: │ └───────────────────────────────────────────────────────────────┘ KISBILL - Keep It Simple Billing and Invoicing System Page: 50 ■ RECALL RECORDS Recalls records previously marked for deletion. This option is identical to the DELETE RECORDS option discussed earlier... ■ RETURN TO MENU Returns to the procedure that called MISC Routines. ■ RUN (DOS COMMAND) Run a DOS command (EG: dir/w). This option is helpful in that it allows you to run programs at the DOS level (within memory constraints). ┌───────────────────────────────────────────────────────────────────────────┐ │ RUN CD\DOS │ └───────────────────────────────────────────────────────────────────────────┘ One useful option is to type and Enter: COMMAND at this prompt. You will be running another DOS Shell totally out of the program (it still is in memory though). ┌───────────────────────────────────────────────────────────────────────────┐ │ RUN COMMAND │ └───────────────────────────────────────────────────────────────────────────┘ Press and Enter: EXIT to return to your Clipper Application. KISBILL - Keep It Simple Billing and Invoicing System Page: 51 ■ SIMPLE EDITOR A simple editor and word processor. Use this option to create and read simple TEXT files. File size is limited to your machines capabilities or 32,000k. The first prompt is for the name of the file you wish to edit. Type in the name, or press Enter on an empty prompt to bring up a window option box containing all files in the current directory. ┌────────────────────────┐ ┌──────────[ EDIT THE FILE ]───────────┐ │ Highlight a file │ │ FILE NAME SIZE DATE USED│ │ using the │ ├──────────────┬────────────┬──────────┤ │ arrow keys, then press │ │B.BAT │ 222 │ 09/16/89 │ │ Enter/Return. │ │BKDOOR.DOC │ 56356 │ 09/17/89 │ └────────────────────────┘ │BKDOOR.ZIP │ 19415 │ 09/16/89 │ │DAYOBK.LIB │ 36879 │ 09/16/89 │ │DAYOBK.LST │ 2056 │ 09/16/89 │ ┌────────│DAYOBK.OBJ │ 35585 │ 09/16/89 │────────────────────────────┐ │ Enter t│DAYOCAL.MAP │ 35 │ 09/16/89 │ │ │ Press E│DDD.DBF │ 375 │ 09/16/89 │urrent directory listing. │ └────────│DDD.DBT │ 512 │ 09/16/89 │────────────────────────────┘ │DDD.NTX │ 2048 │ 09/16/89 │ │DEMO.EXE │ 245404 │ 09/16/89 │ │DEMO.MAP │ 7780 │ 09/16/89 │ └──────────────┴────────────┴──────────┘ More *** Note, this routine will try to load binary files (.EXE, .OBJ, .etc...), so be careful at what you select for viewing/editing. If you make ANY changes to the file, You MUST PRESS Ctrl W to SAVE those changes. If you exit with an Esc, all changes will be lost! ┌──────────────────────────────[ SIMPLE EDITOR ]─────────────────────────────┐ │CLIPPER demo │ │CLIPPER MISC │ │KWAIT 10 │ │LIB MISC-+MISC,MISC.LST,MISC │ │KWAIT 10 │ │TLINK DEMO,,,MISC \CLIPPER\CLIPPER \CLIPPER\EXTEND │ │KWAIT 10 │ │DEMO │ └────────────────────────────────────────────────────────────────────────────┘ Esc (ABORT) Ctrl W (SAVE) Initial Size: 222 1/0 KISBILL - Keep It Simple Billing and Invoicing System Page: 52 Special keys for 'moving around' the SIMPLE EDITOR screen are: Left Arrow Key - Move to your left Right Arrow Key - Move to your right Ctrl Home - Go to the top, leftmost corner of window Ctrl End - Go to the bottom, rightmost corner of window Up Arrow - Move up one line Down Arrow - Move down one line PgUp - Page up a full screen PgDn - Page down a full screen Ctrl PgUp - Go to the beginning of the file Ctrl PgDn - Go to the end of the file * F2 - Import text from a text file * Ctrl W - Save Changes and Exit * Esc - ABORT Changes and Exit The margin may exceed the boundaries on the right side of the screen, but the text is easily accessed using the special keys above... ■ SORT DATABASE This option takes a database, sorts it, and copies the result into a new database. The first prompt is for the name of the database you want to sort. Enter the name, or press Enter on an empty prompt to bring up a window box containing all databases in the current directory. ┌────────[ PICK A DATABASE ]───────────┐ │ FILE NAME SIZE DATE USED│ ├──────────────┬────────────┬──────────┤ │DOG.DBF │ 259 │ 09/16/89 │ │CAT.DBF │ 375 │ 09/16/89 │ │CAR.DBF │ 195 │ 09/17/89 │ │BAM.DBF │ 7335 │ 09/16/89 │ │HARP.DBF │ 103 │ 09/17/89 │ │TRAIN.DBF │ 24387 │ 09/17/89 │ │HIPPY.DBF │ 289 │ 09/16/89 │ ┌────────────────────────┐ └──────────────┴────────────┴──────────┘ │ Highlight a database │ │ using the │ ┌───────────────────[ SORT A DATABASE ]────│ arrow keys, then press │ │ Enter Database Name: │ Enter/Return. │ │ └────────────────────────┘ │ │ └───────────────────────────────────────────────────────────────┘ KISBILL - Keep It Simple Billing and Invoicing System Page: 53 The next prompt is for the name of the database you will be creating with the sorted data. ╒╔═══════════════════════════[ FIELD NAMES & TYPE ]══════════════════════════╗ │║ ║ ╘║PART{C} ■ MFG_PART{C} ■ DESC{C} ■ PRICE{N} ■ LIST{N} ■ YOURPART{C} ■ ║ ║NOTES{M} ■ ║ ╚═══════════════════════════════════════════════════════════════════════════╝ ┌───────────────────[ SORT A DATABASE ]─────────────────────────┐ │ Enter Database Name: INVNET.DBF │ │ Enter Name of Sorted File: INVNET1.DBF │ │ │ └───────────────────────────────────────────────────────────────┘ The next prompt is for the sort field (limited to 1 field)... ╒╔═════════════════════════[ FIELD NAMES & TYPE ]═══════════════════════════╗ ╘║PART{C} ■ MFG_PART{C} ■ DESC{C} ■ PRICE{N} ■ LIST{N} ■ YOURPART{C} ■ ║ ║NOTES{M} ■ ║ ╚══════════════════════════════════════════════════════════════════════════╝ ┌───────────────────[ SORT A DATABASE ]─────────────────────────┐ │ Enter Database Name: TOM.DBF │ │ Enter Name of Sorted File: TOM1.DBF │ │ Enter the Key Expression: PART │ └───────────────────────────────────────────────────────────────┘ ■ TYPE (PRINT) FILE Prints an ASCII/text file to screen or printer. The first prompt is for the file name. ┌───────────────────────[ TYPE TO SCREEN OR PRINTER ]────────────────────────┐ │ Enter the ASCII/TEXT file to TYPE: KISBBS.DOC │ │ Press Enter/Return on an empty field to get a current directory listing. │ └────────────────────────────────────────────────────────────────────────────┘ KISBILL - Keep It Simple Billing and Invoicing System Page: 54 The display of the file (any type), is continuous, but can be paused by any key (except the Enter & Esc keys). Pressing the Enter key will slow the printing of the file onto the screen. Press Esc to Abort the display... A sample display: FUNCKEY...........MISC FUNIQUE...........MISC FZAP..............MISC GET_PIC1..........MISC ISDATA............MISC ISDBF.............MISC MENU_KEY..........MISC MISC..............MISC OKFILE............MISC PACKIT............MISC PICKDBF...........MISC PROCLIST..........MISC SHOW_INS2.........MISC STATLINE2.........MISC TOG_INS2..........MISC XKEY_CLEAR........MISC XKEY_NORM.........MISC XMEMO.............MISC MISC BKDOOR BROWSEIT CENTER1 COLORSET DBFUNCT DBFUNCT6 EDITOR FACHOICE FAPPEND FCOPY2 FDBF1 FDELETE FERASE FILESZ FILE_UDF FILT FINDER FINDEX FMAKEDB FMODYDB FNEW FRECALL FRUN FSCROLL1 FSORT FTYPEIT FUNCKEY FUNIQUE FZAP GET_PIC1 ISDATA ISDBF MENU_KEY MISC OKFILE PACKIT PICKDBF PROCLIST SHOW_INS2 STATLINE2 TOG_INS2 XKEY_CLEAR XKEY_NORM XMEMO PRESS ANY KEY TO CONTINUE... ■ ZAP DATABASE Totally erase all records in database (forever!). When you want to remove every record from a database, then use this option. Use with EXTREME CAUTION! The first prompt is for the file name. Enter the name of the database you are to 'clean out', or press Enter to select the database from a window containing all databases in the current directory. KISBILL - Keep It Simple Billing and Invoicing System Page: 55 ┌────┐ │ZAP!│ └────┘ ┌────────[ PICK A DATABASE ]───────────┐ │ FILE NAME SIZE DATE USED│ ├──────────────┬────────────┬──────────┤ │DENVER.DBF │ 259 │ 09/16/89 │ │OHIO.DBF │ 375 │ 09/16/89 │ │NEWYORK.DBF │ 195 │ 09/17/89 │ │MONTANA.DBF │ 7335 │ 09/16/89 │ │SC.DBF │ 259 │ 09/17/89 │ │EARS.DBF │ 103 │ 09/17/89 │ │FRUIT.DBF │ 24387 │ 09/17/89 │ ┌────────────────────────┐ │MATH.DBF │ 259 │ 09/17/89 │ │ Highlight a database │ │CARROTS.DBF │ 289 │ 09/16/89 │ │ using the │ └──────────────┴────────────┴──────────┘───│ arrow keys, then press │ │ Enter Database Name: │ Enter/Return. │ └──────────────────────────────────────────└────────────────────────┘ You will be prompted one last time as to whether you still want to ZAP the selected database. Press Y for Yes, N for No... ┌────┐ │ZAP!│ └────┘ ┌──────────────────────────────────────────────────────────────────────────┐ │ ZAP TRASH │ │ Are you sure you want to ZAP (remove all records permanently) ? N │ │ │ └──────────────────────────────────────────────────────────────────────────┘ │ Enter Database Name: │ └───────────────────────────────────────────────────────────────┘ KISBILL - Keep It Simple Billing and Invoicing System Page: 56 ■ HELP SCREENS While in the browse screens, some of the option windows, and in the SIMPLE EDITOR, pressing the F1 key, will display a help screen. BROWSE help: ┌───────────────────────[ KISBILL HELP: DBEDIT, 0, ]─────────────────────────┐ │ │ │- Special keys for 'moving around' the BROWSE screen are: │ │ │ │ Left Arrow Key - Move to next field to your left │ │ Right Arrow Key - Move to next field to your right │ │ Ctrl Home - Go to the leftmost field │ │ Ctrl End - Go to the rightmost field (on the end of the record)│ │ Up Arrow - Move highlight to the previous record │ │ Down Arrow - Move highlight to the next record │ │ PgUp - Page up a full screen of records │ │ PgDn - Page down a full screen of records │ │ Ctrl PgUp - Go to the beginning of the file │ │ Ctrl PgDn - Go to the end or last record of the file │ │ Ctrl N - Add a record (where applicable) │ │ Ctrl U - Delete a record (where applicable) │ │ F5,F6,F7 - To seek/find a record based upon the active index │ │ Esc - Exit the current operation │ │ │ │ Remember that there are many more fields to the right of the screen. │ │ Press the right arrow key to view them... │ └────────────────────────────────────────────────────────────────────────────┘ Option Box Help: ┌────────────────────────[ KISBILL HELP: ACHOICE, 0, ]───────────────────────┐ │ │ │ │ │ │ │ │ │ - Special keys for 'moving around' the Option Box are: │ │ │ │ Up Arrow - Move up one option │ │ Down Arrow - Move down one option │ │ PgUp - Page up multiple records │ │ PgDn - Page down multiple records │ │ Esc - ABORT and Exit │ │ │ │ │ │ After highlighting the option you desire, press Enter... │ │ │ │ │ └────────────────────────────────────────────────────────────────────────────┘ KISBILL - Keep It Simple Billing and Invoicing System Page: 57 Editor help: ┌───────────────────────[ KISBILL HELP: MEMOEDIT, 0, ]───────────────────────┐ │ │ │ - Special keys for 'moving around' the EDITOR screen are: │ │ │ │ Left Arrow Key - Move to your left │ │ Right Arrow Key - Move to your right │ │ Ctrl Home - Go to the top, leftmost corner of window │ │ Ctrl End - Go to the bottom, rightmost corner of window │ │ Up Arrow - Move up one line │ │ Down Arrow - Move down one line │ │ PgUp - Page up a full screen │ │ PgDn - Page down a full screen │ │ Ctrl PgUp - Go to the beginning of the file │ │ Ctrl PgDn - Go to the end of the file │ │ Ctrl W - SAVE Changes and Exit │ │ Esc - ABORT Changes and Exit │ │ F2 - Import another text file into your document │ │ │ │ The margin may exceed the boundaries on the right side of the screen, │ │ but the text is easily accessed using the special keys above... │ │ │ │ │ └────────────────────────────────────────────────────────────────────────────┘ ■ EXPANDED HELP After Version 1.3, expanded help routines was added to KISBILL. At almost all prompts and menus you can press F1 for help. Help can be a function key message as displayed on previous page or a message that you have created (user defined & inputted). KISBILL - Keep It Simple Billing and Invoicing System Page: 58 ■ USER DEFINED & INPUTTED HELP SCREENS/MESSAGES If you press F1 and no user defined & inputted message exists for that section of the program you are currently in you will receive a message to this effect, and then a blank/empty screen. The editing keys for this option are the same as for the Simple Editor (previous page). ┌──────[ DAYO HELP Called by Program: KISBILL Variable: OPT ]───────┐ │ │ │ │ │ │ │ │ │ │ │ │ │ ╔════════════════════════════════════════════════════════╗ │ │ ║ No Online Help Messages Exist for this prompt... ║ │ │ ║ ║ │ │ ║ You can type in any help message you wish. ║ │ │ ║ ║ │ │ ║ ║ │ │ ║ ║ │ │ ║ Press any key to continue... ║ │ │ ╚════════════════════════════════════════════════════════╝ │ │ │ │ │ ├───────────────────────────────────────────────────────────────────────────┤ │ Esc (Exit) Ctrl W (Save Changes) F1 (Read Manual) │ └───────────────────────────────────────────────────────────────────────────┘ If you wish to input anything at this point, just type whatever you wish, remembering to press Ctrl W to save all changes. Pressing Esc will not save ANY changes ( all effort you put into writing a help message will be lost! ). * * * Press Ctrl W to save your changes!!!! * * * KISBILL - Keep It Simple Billing and Invoicing System Page: 59 DAYOINV V1.3, TJS LAB ┌────[August 1990]──┐ ┌───────[ DAYO HELP Called by Program: KISBILL Variable: OPT ]───────┐ │ │ │ │ │ │ │ │ │ Type in anything you wish about this portion of the program! │ │ │ │ The length of this file can be many pages... │ │ │ │ Be sure to press Ctrl W to save any changes/additions you make to this │ │ screen. │ │ │ │ │ │ │ │ │ │ │ │ │ ├────────────────────────────────────────────────────────────────────────────┤ │ Esc (Exit) Ctrl W (Save Changes) F1 (Read Manual) 13/4 │ └────────────────────────────────────────────────────────────────────────────┘ KISBILL - Keep It Simple Billing and Invoicing System Page: 60 ■ DATABASE STRUCTURES Structure for database: INVOICE.DBF Field Field name Type Width Dec Start End ───── ────────── ───────── ───── ─── ───── ─── 1 ITEM Character 12 1 12 1 INVOICE Numeric 8 1 8 2 NAME Character 30 9 38 3 CUSNUM Numeric 8 39 46 4 ATTN Character 30 47 76 5 ADDRESS1 Character 30 77 106 6 ADDRESS2 Character 30 107 136 7 CITY Character 17 137 153 8 STATE Character 2 154 155 9 ZIP Character 10 156 165 10 PHONE Character 14 166 179 11 TERMS Character 14 180 193 12 DATE Date 8 194 201 13 BY Character 15 202 216 14 CUST_PO Character 15 217 231 15 TAX Logical 1 232 232 16 ADJUST Numeric 10 2 233 242 17 FREIGHT Numeric 10 2 243 252 18 SUBTOTAL Numeric 10 2 253 262 19 OPEN Logical 1 263 263 20 PAID Numeric 10 2 264 273 21 DUE Numeric 10 2 274 283 22 COMMENT Character 50 284 333 23 TAXES Numeric 10 2 334 343 ────────── ───── Total 344 Structure for database: DETAIL.DBF Field Field name Type Width Dec Start End ───── ────────── ───────── ───── ─── ───── ─── 1 ITEM Character 12 1 12 1 INVOICE Numeric 8 1 8 2 ITEM Character 10 9 18 3 DESC Character 30 19 48 4 QTY Numeric 9 3 49 57 5 PRICE Numeric 10 2 58 67 6 DATE Date 8 68 75 ────────── ───── Total 76 KISBILL - Keep It Simple Billing and Invoicing System Page: 61 ■ DATA DICTIONARY Field Name Type Len Dec Database Description/Comments ────────── ──── ─── ─── ──────────── ────────────────────────────────── ADDRESS1 C 30 0 INVOICE.DBF 1st line of the customer's address ADDRESS2 C 30 0 INVOICE.DBF 2nd line of the customer's address ADJUST N 10 2 INVOICE.DBF Adjustment value ATTN C 30 0 INVOICE.DBF Attention/Contact name BY C 15 0 INVOICE.DBF Name of the user that made the invoice CITY C 17 0 INVOICE.DBF City COMMENT C 50 0 INVOICE.DBF Comment placed onto the invoice CUSNUM N 8 0 INVOICE.DBF Customer's number CUST_PO C 15 0 INVOICE.DBF Customer purchase order number DATE D 8 0 INVOICE.DBF Date invoice was created DETAIL.DBF DESC C 30 0 DETAIL.DBF Description of detail item DUE N 10 2 INVOICE.DBF Amount still due on invoice FREIGHT N 10 2 INVOICE.DBF Freight value INVOICE N 8 0 DETAIL.DBF Invoice number INVOICE.DBF ITEM C 10 0 DETAIL.DBF Item/Product/Part number NAME C 30 0 INVOICE.DBF Customer's name OPEN L 1 0 INVOICE.DBF Flag to denote whether invoice is open or closed PAID N 10 2 INVOICE.DBF Amount received from customer as payment on the invoice PHONE C 14 0 INVOICE.DBF Customer's telephone number PRICE N 10 2 DETAIL.DBF Price of an item QTY N 9 3 DETAIL.DBF Quantity sold per item STATE C 2 0 INVOICE.DBF State SUBTOTAL N 10 2 INVOICE.DBF Subtotal of the detail item ( Cost * Quantity) TAX L 1 0 INVOICE.DBF Flag to denote whether the invoice is to be taxed TAXES N 10 2 INVOICE.DBF Amount of taxes charged TERMS C 14 0 INVOICE.DBF Invoice terms, ie: CASH, CHECK, NET 30, NET 60, DUE NOW! ZIP C 10 0 INVOICE.DBF Zip code KISBILL - Keep It Simple Billing and Invoicing System Page: 62 ■ TJS 'Computer' LAB TJS LAB is an association of programmers and technicians that produce customized, multiuser software for the PC based network (ie: Novell (tm) and others). Our specialties include Inventory Control, PC Communications/EDI, Management, Reports (standard and graphic), Data Conversions, and some Accounting (A/R, A/P). A unique feature of TJS LAB is that our software is by default, multiuser. 'Standalone' applications are the exception! All our applications are written in Clipper, Basic, or C (preferably Basic or Clipper). We will license all our application source codes. We produce applications that work, are easy to use, and are inexpensive! Want a change? Want an enhancement! Want a completely new product/application? Want to make your idea a reality? Custom/contract programming, by TJS LAB, and our associates is available. Standard rate is $35.00 per hour (our sites). Guarantees for quality and timely work is our number one rule ('Do it now, do it right, do it cheap!'). We make program enhancements/changes/fixes at our location(s), but can/do make 'house calls' via special software and a modem. Write us at: TJS LAB PO Box 585366 Orlando, Florida 32858-5366 Or use our voice mail/answering machine (24 hours/day) * (407) 291-3960 * Note that TJS LAB, nor any of the associates accept/take any support calls for unregistered Shareware products. KISBILL - Keep It Simple Billing and Invoicing System Page: 63 ORDER FORM: KISBILL Keep It Simple Billing & Invoicing System For the cost of registering/licensing this Shareware Software, you will receive the latest version of this program without any logos or delays screens. You will also be notified of upgrades and of other TJS LAB products! A Source Code License is available. KISBILL is written with Nantucket's Clipper (dBase (tm) compiler), using the Funcky library by dLESKO Associates. A Source Code License means you have the right to use & modify the source codes for your personal/business/network needs, but no rights to resell any part of it without the prior written consent of TJS LAB. COST QTY ------ ----- KISBILL Registration ............................... $25.00 _____ KISBILL Source Code License ........................$305.00 _____ (The Source Code License includes the registration fee) TOTAL: __________ ┌───────────────────────────────────┐ Check or Money Order Only Please. │ Note: The Registration Copy will │ --------------------------------- │ be mailed to you on a 5.25 floppy │ └───────────────────────────────────┘ Print Your Name and Address Clearly... Mail To: Name: _______________________________ TJS LAB Address: _______________________________ Attn: KIS SALES PO BOX 585366 _______________________________ Orlando, Florida 32858-5366 _______________________________ *** Check out KISBILL's big _______________________________ brother -> DAYO! Any Special Instructions/Comments? (Please!) ____________________________________________________________________________ ____________________________________________________________________________ ____________________________________________________________________________